I have 2 tables.
CustomersQB - This table contain data retrieved from Quickbooks using ODBC.
Customers: This is filmmaker table also contain customers data but all the fields in this table use "LOOK UP" from "CustomersQB" table. The reason I have done it this way so I can add global keys. I cannot add globel keys in ODBC connected CustomersQB table.
So my layouts are based on Customers table. And because I'm using look up feature, I can see the actual quickbooks data and do all the filtering.
My problem is that If a new customer is added in Quickbooks, that will also appear in CustomersQB table. Currently, I copy the key of newly added customer and paste in Customers table so with the relationship and loop up, I can get all the information about customers.
It's done manually. I was looking to do it automatically. So when new customer is added in customerQB table, the key of that customer also gets entered in Customer table.
What would be the best way to achieve this. So keys of parents table are auto entered in child table.