Bulk insert records with foreign key

[jg80]

Hi @MFP - similar question and resolution here:

Insert 2 records (2 tables) with linking foreign key

Hi, I'm fairly new with Retool concept, and I'm not proficient enough to keep things simple. I have 2 tables (say, 'tennant', and 'tennant_account' which hold the foreign key of corresponding 'tennant') When creating a tennant, I'd like to create the corresponding account at the same time. I need to have the uniqueId of the inserted 'tennant_account' as Foreign Key to populate the 'tenant' record. How would I do that with as little clutter as possible (possibly in a Retool resource Query - …

Take a look and let us know if you need any further help!