Table References and Relations

Hi Birger,

Done.

The name of the tables is in french. So here're some translations:

- Devis clients: quote

- Facture clients: invoice

- Ligne devis: items quote

- Client: customer

- Grilles tarifs forfaits: price list of services

Regards,

Laurent.

How can I create a 1: 1 relationship between two tables? I need to relate an item from a supplier to a single sales item.

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

Thanks Leonid. Very Helpful!