Forum Discussion
Data connection issue
Hi all, I have 2 tables and need to make a connection between them . Coulmn 'Account' should be same in both tables ( both 'Account' columns have duplicate values with different IDs) . I am tryi...
Thanks Kishore_KVN by deleting the duplicate values , doesn't it affect the data accuracy? For examle I have 120 records with same Account name but different contract name. Each of thoes 120 records are not same Account that has been used for different contracts, each are specifically a row of values.
No it will not miss any information as its going to be just a bridge table it will just help to connect two other tables thats it.
Unfortunately didn't work, it gives me Many to Many relationship