a Critical Database Design.

[cap.zadi]

Hey there,

I am looking to develop a database to print lables for packaging. Here is the information:

TblePrdInfo
PrdID (PK)
PrdName
PackingClass
StndClass
Note


tblebatchInfo


BatchID (PK) - AutoNumber
BatchDate


Lets say dated on 20/11/2011 make 10 Batch. So now i need to print the packing lable to past on the each batch packaging.

how do u proceed to develop this database. where i can print just say 20 lables on this date for the following products so it should printed with auto batch number and a serial number which presents Barcoding on label.

please advise.

thanks.

zee

[orange]

You could start here
http://office.microsoft.com/en-us/ac...010007352.aspx

[cap.zadi]

thanks man