Box Labels for Receiving Database

[Jons9er]

Hi All,

Bare with me as I'm a new Database maker, but my company has asked me to make a receiving database that handles all our incoming receipts,tracks them from when they coming through the door to when they are put away into inventory so that we gain transaction trails that our system lacks.

I have been able to create everything except one thing they want the database to do.

I have the users entering the information into a receipt log form so for each receipt(shipment)creates 1 record in the receipt table. Unfortunately each receipt can have multiple boxes, what they would like is that the database will print out labels for all the boxes that contain all the information contained in that individual receipt record.
What I need to be able to do is have a field on the receipt form where the user can enter the number of boxes on the shipment then be able to program the label report to print multiple labels for the same record for the number of boxes on the shipment coming in?

Any ideas on how I can accomplish task?

Thanks,
Jons9er

 

[GingerR]

Would you also want on each label, say if there are 3 boxes total, the count? i.e.

Box 1 of 3
Box 2 of 3
Box 3 of 3

or anything like that?

Please post your table structure. Field names, table name. There should be some kind of ID field and then an integer field that holds the number of boxes. Thanks.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Jons9er]

Hi GingerR,

Here is my table structure:
Table Name, DockLog
ProductID, AutoNumber (Primary Key)
PartNumber, Text
Quantity, Text
Vender, Number
DockDate, Date/Time
PurchaseOrder, Text
ReceiptDate, Date/Time
Received, Yes/No
AuditDate, Date/Time
Audited, Yes/No
DockEmployee, Text
ReceiptEmployee, Text
AuditEmployee, Text
Notes, Memo
Numberofboxes, Number

You are exactly right what I want is a label report that will print box 1 of 3 with the item number, purchase order number, etc and then do the same thing on box 2 of 3. I have been able to make a label report but all I can get it to do is make 1 label for each record.

I know this has to be something simple that I'm just missing as it has to be something quite common such as a parameter query that duplicates records.

Thanks for your help,
Jons9er

 

[GingerR]

So what's it based on? The ProductID?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[GingerR]

I just found a FAQ for you which should work:

faq703-3276

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244