0

table relation suggestion

This is my first approach to the databases and although I think it is a very intuitive application, still can't get the result I want. I made a "materials", "items", "layouts (paper sizes)" and "orders" to control a printing house's workflow. I set the first three without problems, but I understand that to make that "orders" can be repetitive with different quantities, different items, it is a many to many relationship, but at that point it already seems confusing to me. ¿Any advice?, thanks in advance.

1 reply

null
    • Mconneen
    • 4 yrs ago
    • Reported - view

    @Carlos, 

    The good and the bad of "forums" like this is....  The good.. there is a TON of information in it..   The bad.. it is often hard to find it.. 

    As I recall having a chat about this some time ago.. I searched this forum for "Many to many relationship"..  And got a list of hits.. and saw that one I was looking for. 

     

    This is the thread for you.  There is also a few references to a Ninox Partner's (Julian's) blog where he publishes step by step tutorials! 

     

    https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/many-to-many-relationships-5cdae71cfdf7f57862667560