record continuity

[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]

... a third form that collects the remaining information.

Remaining information for which record?

-dK