Thread: PO generator
View Single Post
Old 07-22-2019, 09:44 AM   #14
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,930
Thanks: 13
Thanked 1,527 Times in 1,453 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: PO generator

As a start, the first two tabs will be separate tables and all the little tables on the third tab will be separate tables. Then the repeating part of the PO sheet will become the PODetails table and will contain 1 occurrence of description, price, and qty plus a foreign key that points to the POID of the PO table. So instead of fixing the number of items per PO at 30, each PO can have as many items as you need it to have.

Once you get that done, post back.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
The Following User Says Thank You to Pat Hartman For This Useful Post:
TheJoeness (07-22-2019)