I have a Google Form and two Ninox tables. I am using Zapier to glue them together (if that makes any difference).

What would be a good pattern to split the data from the form into two tables while creating a reference between the records at the same time? 

I was thinking about creating an incoming table to store all fields and to write scripts that create entries in the two tables, but I am not sure if this is the best approach. 

I would be very thankful for any suggestions.