Auto fill objects in form

[Guest]

I want to be able to enter data in a form for the first record, then when I
add the next record it will automatically fill certain cells.

Employee # Acct Code Rate Last Name First Name

99999 RGLR $10 Smith John


99999 Smith John

The first record I will enter data into each field, each record to follow I
only have to enter the new Acct Code and Rate.

Any ideas?
Thanks,
Jason

 

[Rick B]

Either do a search and read the previous posts on this topic, or open the
Northwinds sample database and look at how it does this when you select a
cutomer when creating a new order.