Selecting the correct record

[Dazza666]

Hi,

I have a couple of tables Client and clientRecord.

Client is linked to ClientRecord in a one to many relationship i.e. clients can have multiple records,

I collect most of the information in a single form.

In a second form I have a button that takes me to a third form that collects the remaining information. Basically what I need is to ensure that when the button opens the third form it always opens the details for the 1st ClientRecord instead of creating a new client record for the remaining info.

at the end of filling both forms the table should be

field1, field2, field3, field4, field5, field6, field7,
x x x x x x x


not (in seperate records)

field1, field2, field3, field4, field5, field6, field7,
x x x x

x x x


Also no navigation buttons can be present, I need this to be seamless to users so they don't have to worry about record ID's etc

thanks

 

[dkinley]

Please do not post the same problem multiple times.

-dK