T
TLB
I am in the process of building a form in MS Access 2000. The form is
similar to a purchase order or bill of laiding. The top of the form has data
entry fields as follows; Vendor Name, Vendor address, PO #, and Date (Ect).
On this same form, I want to enter one, or multiple PO or Bill of laiding
line items which will contain the following fields; part numbers, part qty's
for each part number, and part weights for each part number. I don't want to
enter all of the form info entered at the top of the form for each of the
part numbers, so how would I make the form and associated table so that the
information at the top can be tied to each of the part numbers added to the
form. I can't seem to get passed the issue that one form equals one record,
when I'm trying to use the one form to enter multiple records. This seems
like a one to many type operation which I can't seem to figure out. Any
suggestions would be appreciated.
Thanks,
similar to a purchase order or bill of laiding. The top of the form has data
entry fields as follows; Vendor Name, Vendor address, PO #, and Date (Ect).
On this same form, I want to enter one, or multiple PO or Bill of laiding
line items which will contain the following fields; part numbers, part qty's
for each part number, and part weights for each part number. I don't want to
enter all of the form info entered at the top of the form for each of the
part numbers, so how would I make the form and associated table so that the
information at the top can be tied to each of the part numbers added to the
form. I can't seem to get passed the issue that one form equals one record,
when I'm trying to use the one form to enter multiple records. This seems
like a one to many type operation which I can't seem to figure out. Any
suggestions would be appreciated.
Thanks,