0

Table References and Relations

Please provide a little more detail for your Person, Company, Employee example. What I specifically need is what you have to put in each table to tie them together, since what I have been guessing is not working.

Danke sehr!
55replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • 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.

    Like
    • Antonio
    • Antonio
    • 4 yrs ago
    • Reported - view

    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.

    Like
    • kane86
    • kane86
    • 4 yrs ago
    • Reported - view

    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!

    Like
  • 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

    Like
    • kane86
    • kane86
    • 4 yrs ago
    • Reported - view

    Thanks Leonid. Very Helpful!

    Like
Like Follow
  • 4 yrs agoLast active
  • 55Replies
  • 22855Views