Record Copy Help please

[Ted Wilson]

I have a record on table1 columm called userID and I would like to
automatically insert this value into table2 columm userID2 everytime I insert
a new value in userID table1. Can anyone please tell me how to do this in
Access2003? Mind you I using ASP and

thanks

 

[John W. Vinson/MVP]

I have a record on table1 columm called userID and I would like to
automatically insert this value into table2 columm userID2 everytime I
insert
a new value in userID table1. Can anyone please tell me how to do this in
Access2003? Mind you I using ASP and

thanks

It's VERY rarely necessary or appropriate to automatically create an empty
"placeholder" record. It's best to create the link at the time you actually
have data to insert into the related table. In Access desktop you can use a
Form with a Subform; I'm not expert in ASP but my understanding is that you
need to pick up the ID from the "parent" record and fill it into the child
record when it's created. But in practice, such empty "placeholders" very
often get left empty.

John W. Vinson/MVP