Circular references, need ‘related stuff’ in both tables

[leonrothenberg]

Learning Appsheet proceeding well. I’ve come across an interesting issue and wondering the best way to solve it.

Building a database of card games, 2 tables in question: Decks and Games (there’s also a card table but it’s unrelated to this issue) The tricky bit is that some Decks can be used for multiple games (like a standard deck of playing cards), and some games have multiple decks (like a CCG or board game like Pandemic). I’ve got reference fields from each to the other, so Games has related decks and decks has related games, and it works /mostly/ but breaks and/or yields confusing results on an interactive dashboard. It seems like Decks needs a second key to handle the multi-deck game, but that’s not possible.

Any advice on the best way to do this? It’d be nice to do something streamlined and elegant rather than adding a second deck table.

Thx.

[Paras_Sood]

It seems like you will need to add another table to handle this many-to-many relationship with primary foreign keys from both the tables to depict the relationships