Unanswered: Help on making a dynamic table / (need some ideas on the logic part)
I am currently working on a database to keep track all of the purchase orders we issue. Right now I am facing a problem. I have a framework for the database done but the problem being that the amount of items on the purchase order can vary. It can vary from 3 items up to 80 items.
I would like to keep each purchase order as one record but the form I have made (which fits on a letter page nicely) is only capable of recording 22 items. Also, I know the way I set it up is not very flexible because I have 22 Items * 4 fields for each item (Unit price, total price, description, quantity) = 88 fields whenever a new purchase order is made.
I would like to hear you experts on how to make this database more dynamic since the number of items do change from PO to PO.
Thank you very much for taking your time to answer my question.