On Tue, 21 May 2019, Adrian Klaver wrote:
The other way is to create the org_id for each organization ahead of time and put it into the data file. Either way you have create the org_id for the FK relationship, it is just a matter of where and when.
Adrian, I had thought of that but overlooked it. The max(org_id) number is 338 so I can assign sequential numbers above that as I format the data for the insert scripts. Thanks for the reminder, Rich
