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
-
@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!
Content aside
- 4 yrs agoLast active
- 1Replies
- 600Views