I’m a DB noob, so apologies for possibly using the wrong terms :-).
I have an Integromat automation running, which pulls order data off a online marketplace. One set of data populates an “order” table in NocoDB, and the second set of data populates an “order details” table showing each order’s SKU line items.
I currently manually link each “order” to the multiple “order details” using the same order ID as key, so that I can display specific data from one table in the other via lookup.
Is there anyway of automating that step within NocoDB? I assume that is meant with automatically joining tables with foreign keys, but any guidance would be appreciated