Hello,
I have always, and successfully, related parent and child tables having the same field name as primary and foreign key. For example, customers and orders through their own common CustID field (defined in each table) with a SET RELATION command.
Now, suppose that I wanted to rename the CustID fields (as some have suggested in literature) to CustSID in the parent table (primary key) and CustKey in the child table (foreign key). How am I supposed to do that using the same SET RELATION command?
Thanks,
Dario
I have always, and successfully, related parent and child tables having the same field name as primary and foreign key. For example, customers and orders through their own common CustID field (defined in each table) with a SET RELATION command.
Now, suppose that I wanted to rename the CustID fields (as some have suggested in literature) to CustSID in the parent table (primary key) and CustKey in the child table (foreign key). How am I supposed to do that using the same SET RELATION command?
Thanks,
Dario