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