Related Table
Sandro
Posts: 1 New member
How do I proceed if I have several tables and these are linked to each other?
For example, I have a table with roles. These roles have a name. Now I want to synchronise them.
The key is the role name.
If I now add a second table. E.g. role surfaces layout.
The key of the role table is now in this table.
How can I now make it not take the key of the role but the role name as a reference and then search for the ID there?
I would like to be able to configure the comparison key and this lookup for each table.
Can I do this in DataCompare?
Can I do this in SQL SourceControl?
