Filter JSON objects between tables

I’m working on a project using tables ‘products’ that go into ‘orders’. I’m creating a work around to automate a PDF of the details of the order using DocsAutomater and thus have created JSON objects of the products but when i make a joined list of the products in the corresponding order in the ‘orders’ table, it makes a joined list of all of the products rather than the ones just in that order. Any suggestions?

Is your joined list using the relation or the table?

Not sure I understand what you mean, could you expand?

Show us a screen shot of the configuration of your Joined List column.

1 Like

Yes, that’s your problem. You’re joining every row in the Products table.
You should have a multiple relation between your Orders table and your Products table (Products per Order), and then create the Joined List via that relation.