This scenario calls for a classic One-to-Many Relationship. Basically you need two tables.
First table stores information such as PO Number, PO date, company/person ordering, etc.
Second table stores the line item data, such as Item, Qty, Unit, Rate, Amount and PO Number.
The PO Number will be used to link the two tables.
You will then need to use a Main Form/Subform to enter and display your data.
The Main Form will display information from the first table. PO Number, PO Date, etc.
SubForm will display the information from the second or line item data table. Item, Qty, Unit, Rate, Amount and PO Number.
total Qty and total amount would typically be calculated and placed in a field in the Footer section of the SubForm, then referenced by an Unbound Textbox in the Main Form.
Also, since you're in the early stages here, note this about names in Access.
You cannot use names with periods in them, such as PO.No and Po.Date. You really should avoid all special characters except the Underscore _.
You should avoid names with spaces, as this requires special handling in Access and frequently leads to problems. Instead of total Qty use total_Qty or totalQty.
And avoid Reserved Words, such as Date. This, too leads to all kinds of problems. Use PODate or PO_Date instead.
Last edited by Missinglinq; 02-23-11 at 11:25.
Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007