serial number

[krishnanhemanth]

hi everybody

iam stuck with a requirement

let me explain...

• a customer has brought 10 water taps.

• each water tap has a unique serial number

• the serial number is alloted on a form with reference to the customer order number
• i generate a invoice based on the customer order number

what i want is
the invoice report should also carry all the serial numbers
how do i do it

please help

krishnanhemanth

 

[Trevor G]

Do you store the numbers on the form in a table if so then you can create a query from the table(s) then produce the report based on the query and possibly use groups in the report so you see the customer name once then all the items they have purchased from you.