Forum Discussion

standenman's avatar
standenman
Copper Contributor
Jul 24, 2022
Solved

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...
2016
access
  • George_Hepworth's avatar
    George_Hepworth
    Jul 25, 2022

    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.

     

George_Hepworth's avatar
George_Hepworth
Silver Contributor
Jul 25, 2022

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.

 

Resources