Have next 2 - related - tables:
t1_AUTOID (autonumber, related to t2)
t1_autoid_rel (related one-many with t1)
Now, when adding a new related record to t2, I want the latest t1_base_number to be copied to t2_new_number.
t1_base_number changes all the time, but when I've added a new t2-record, after that the t2_new_number shouldn't change anymore.
So just copy the latest version t1 number to the t2 field.
Prefable no SP... but in a view? VB-code in Access front-end is ok as well..