M
Mike Revis
Hi Group
Access 2000 win xppro
I have one table for jobs. tblJob.
Each job can have many packages. tblPackage.
Each package can have many contents. tblparts.
Almost all jobs have a customer reference number.
The customer reference number has to be printed on the label for each
package.
Up until recently there has only been one reference number for each job. I
put a field txtCustRef in tblJob and caused it to be printed on each package
label.
Now I have the situation where a customer wants different reference numbers
on each package.
That was easy enough to accomplish by moving txtCustRef to tblPackage. Now I
can enter the reference number at the package level.
My dilemma is in trying to automate the repetition of the reference number
for each package record if the reference number is the same for all
packages.
As always any thoughts, comments or suggestions are welcome.
Mike
Access 2000 win xppro
I have one table for jobs. tblJob.
Each job can have many packages. tblPackage.
Each package can have many contents. tblparts.
Almost all jobs have a customer reference number.
The customer reference number has to be printed on the label for each
package.
Up until recently there has only been one reference number for each job. I
put a field txtCustRef in tblJob and caused it to be printed on each package
label.
Now I have the situation where a customer wants different reference numbers
on each package.
That was easy enough to accomplish by moving txtCustRef to tblPackage. Now I
can enter the reference number at the package level.
My dilemma is in trying to automate the repetition of the reference number
for each package record if the reference number is the same for all
packages.
As always any thoughts, comments or suggestions are welcome.
Mike