0

How to manage two-way multiple table references?

Hello, I am new to Ninox, and new to any kind of database building so please excuse me if this is a naive question.

I am building a database for farm records that include 'Plots' and 'Inputs'. A single 'Plot' may have multiple 'Inputs' (so far so good), but the problem is that a single 'Input' is likely to be associated with multiple 'Plots' (confusion). How do I manage this relationship in a Ninox database? 

Many thanks

Ben

2 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    Have you already looked at the Invoice template? I think this could be comparable with your case, where 'plots' are invoices and 'inputs' are the articles.

    Steven

    • Earthsong Seeds
    • Ben_Heron
    • 4 yrs ago
    • Reported - view

    Thanks Steven. Yes, that was helpful and I think I have a solution now.

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 900Views