Forum Discussion
Rather complex Append Query
I am trying to update client records from information provided in a Zoho online form - a csv file. The data, however, is spread over several tables and involved one to one and one to many relationsh...
standenman This is as close as I come to a flat out "never".
Never try to append records to multiple tables in a single query.Start with the One-side tables. Append their records.
Then use the resulting Primary Keys in subsequent appends to the Many-side tables.
Of course, that requires you to have enforced Referential Integrity on all relationships. The screenshot does show that, and that's a potential red flag.
- Related yes, but different question.
