
Table References and Relations
Danke sehr!
-
Hello! I'm evaluating Ninox and I'm struggling to create a proper relationship between to tables. I have a table called 'Shots' which holds all the shots of a movie production and a table called 'Equipment' which holds items that are used for each shot (cameras, gimbals, lenses...). Now each item can be used for multiple shots and each shot uses multiple equipment items. I can always only select multiple items in one direction depending on how I link the two tables but never both. What is the right way to solve this? Thanks for your support!
-
You need an extra table with n: m relationship. I have a sample database here.
https://www.dropbox.com/s/caho8ua137zrwgs/SHOTS.ninox?dl=0
The shots are visible. Other tables are invisible, you can view them under Data Model
Regards
Leo