I have a Parent table (Clients) with 2 child tables (Visits) and (Members).
The original data was imported.
Parent has field unique Client_ID that was set as key.
Visits has the fields Visits_ID that was set as key and a ref Client_ID to the client.
Same structure for Members.
After import everything looks great, with Members and Visits listed with the appropriate Client.
UNIQUEID() is the initial value for all key fields.
Adding child records inline (hope that is the correct term). The Members,Visits records are created but they don’t have a Client_ID ref value - they are orphans.
What am I missing?