record set

[steve111]

hi,

I have a subform in my customer details form
in that form is shipping details. I could have 3 shipping address per customer

is it possible to use the record set number to use in a query to select the correct shipping address in my report

steve

 

[smig]

what do you mean the RecordSet number ?

 

[steve111]

hi
the number of the record not the auto number

 

[Minty]

Each shipping address has a unique ID? simply store that on your invoice/job record/call record top level record, along with the account code for the customer to enable it to be joined in a query.

 

[smig]

any field that will uniquely identify the shipping address can be used.

 

[steve111]

I was going to put a field in with a number in it ie first record no1 second record no 2 etc for each customer then get a prompt in the query to enter either 1 or 2 as this is an easy number to remember.

but with the help you have all been giving me in all my posts I know this might be the incorrect way.

steve