schedulermpm
New Member
- Joined
- Nov 15, 2005
- Messages
- 2
Having been recently dubbed "Access guru" for our operation ( on the premise that I could pronounce Access , and knew it was a database program ) I am now confronted with a form problem .
I need to be able to set up a form that will allow users to input data from a packing list . The packing list has header data that contains part number , PO, etc . The detail part of the list is the serial number and quantity information for the items in the shipment.
The packing slip will only have on part number / PO / etc but may contain many serial numbers. I need the information in the packing slip to populate a table (s ? ) that identifies each serial number as a unique record.
I have designed a basic form that can handle one serial number at a time but want to be able to enter multiple serial numbers without having to re-enter the header data.
I know that this is probably an easy task and if the data was going to be used in Excel I wouldn't be floundering .
So please take pity on the novice and give me some direction.
All help is appreciated . I tell everyone I know about this forum and have gotten excellent feedback from co-workers who have visited. Thanks again for any assistance.
I need to be able to set up a form that will allow users to input data from a packing list . The packing list has header data that contains part number , PO, etc . The detail part of the list is the serial number and quantity information for the items in the shipment.
The packing slip will only have on part number / PO / etc but may contain many serial numbers. I need the information in the packing slip to populate a table (s ? ) that identifies each serial number as a unique record.
I have designed a basic form that can handle one serial number at a time but want to be able to enter multiple serial numbers without having to re-enter the header data.
I know that this is probably an easy task and if the data was going to be used in Excel I wouldn't be floundering .
So please take pity on the novice and give me some direction.
All help is appreciated . I tell everyone I know about this forum and have gotten excellent feedback from co-workers who have visited. Thanks again for any assistance.