In a recent forum message, B.Cope wrote:
"I am new to access and I am building a DB for a small manufacturing company. I am having a hard time figuring out how to handle Purchase Orders with multiple Items. Some orders only have a few items, like 1-5, per PO but others have as many as 30 or 40 different item types per PO. Additionally frequently the PO calls out for multi-items to be delivered with diferent delivery schedules. i.e. 3-4 delivery dates with varing quanities. Several of the reports required need detailed listing of the items to be shipped with their part numbers, descriptions dwg numbers (etc) and not necessarily in the item number order shown on the PO."
Can you help? Interested in answers to the same question? Visit the About Databases Forum and join the discussion!
"I am new to access and I am building a DB for a small manufacturing company. I am having a hard time figuring out how to handle Purchase Orders with multiple Items. Some orders only have a few items, like 1-5, per PO but others have as many as 30 or 40 different item types per PO. Additionally frequently the PO calls out for multi-items to be delivered with diferent delivery schedules. i.e. 3-4 delivery dates with varing quanities. Several of the reports required need detailed listing of the items to be shipped with their part numbers, descriptions dwg numbers (etc) and not necessarily in the item number order shown on the PO."
Can you help? Interested in answers to the same question? Visit the About Databases Forum and join the discussion!
Comments
No comments yet. Leave a Comment