hey...
"As far as the changing codes every day thing, that should be simple enough - just create a barcode from a unique customer id and a number representing the date (like 12042009). That will give you a unique barcode every day"
For instance: say if jeff stays for a week and sue stays for 2days, i would need to create 7 different barcodes for jeff and 2 different barcodes for sue? and just assign them to a date? would i need to create a seperate table for this or can it be done in my existing customer details table?
another question: now that the barcodes have been created, using the properties of the barcode i have "control sourced" it to the customer id, which is the primary key but how to do i go about assigning an individual barcode to a particular customer?
is it sumthing like Customer ID [field 1] would i have to use VB? i'm not sure
Appreciate ur help
"As far as the changing codes every day thing, that should be simple enough - just create a barcode from a unique customer id and a number representing the date (like 12042009). That will give you a unique barcode every day"
For instance: say if jeff stays for a week and sue stays for 2days, i would need to create 7 different barcodes for jeff and 2 different barcodes for sue? and just assign them to a date? would i need to create a seperate table for this or can it be done in my existing customer details table?
another question: now that the barcodes have been created, using the properties of the barcode i have "control sourced" it to the customer id, which is the primary key but how to do i go about assigning an individual barcode to a particular customer?
is it sumthing like Customer ID [field 1] would i have to use VB? i'm not sure
Appreciate ur help