I am new with FM and new to DB construction in general. My question, what is the best method to limit relationships to a max qty while maintaining serial identification/Traceability? For example, 5 pill bottles per box.
I tried a line items table method with five occurrences of the bottle, but was unable to ensure the same serial number was not used across occurrences, only within occurrences. Attached is an example of the relationship diagram.
Something simple is missing, I am aiming to try to control the data with little scripting. Any thoughts on how to re-arrange the tables/Fields?