I want to put an intermediate table in the database

Need help Database
1

I want to create an N-to-N database structure.
For that purpose, I want to use an intermediate table to create a relationship.

2

Ok… great.

1 Like
3

How do I build it?

4

I’m assuming you just want a table to reference items from table A against items from table B. For that, just make a new Data Type called AtoB (or whatever you want). This data type should have 2 fields: A of type A and B of type B.

This should be more that enough to create references. To search up these references, you’d be querying like “Do a search for AtoB” > A = (item A # 1) and it should give you all the relevant items - you could extract the B from them using something like “:each item’s B”