Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
in the Table viewer , considering 3 Tables
1. QA
2. TeamList
3. New
QA Table is linked with New Table based on a common key named as Key_QA. (Key_QA is the combination of Month and Platform)
TeamList is linked with QA and New Table based on QA_BankID and BankID. (To Avoid synthetic i have renamed BankID as QA_BankID)
But it creates a circular reference. How do i avoid it
Hi,
Comment the QA_BankID column in the QA table and check whether the values are matching.
Regards
Jagan.
How do i get the Location which is in the TeamList
If you elaborate more on your data model, it will be more helpful to understand & suggest the linking of tables
Already there is a link between Team & New tables using the BankID so you will get the locations.
You have to break the relation between any of this tables TeamList, New & QA, then only this is resolved. Based on the business requirement break the relation by renaming any key column names.
Hope this helps you.
Regards,
Jagan.
Hi Senthil,
Can you attach the sample data?