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?
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.
Thanks Steven. Yes, that was helpful and I think I have a solution now.