Automatic linking of tables

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

@omnimercador automatic linking of records is not supported currently. This feature is in our roadmap. You can upvote for it here
:flashlight: Feature: Use existing columns between two tables to create a relationship.

1 Like