Question Create a purchase order in Access 2007

ReJoice

New member
Local time
Today, 06:11
Joined
Oct 30, 2010
Messages
1
What is the best way to capture data in a purchase order table/form to track suppliers, cost, product size, etc. that can be merged into a finished Purchase Order that I can send to my supplier. The goal is to collect the data we enter on the purchase order. Currently created PO in excel and typing over the data for each new PO. Please help Thanks
 
Table1 - Customers
Table2 - Products
Table3 - Product costs
Table4 - Purchase orders

Table4 does all the work.
PurchaseOrderNumber
PODate
POCustomer (from Table1)
POProduct (from Table2)
POProductCost (from Table3)
 

Users who are viewing this thread

Back
Top Bottom