Record Copy Help please

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ted Wilson - 30 Sep 2005 15:25 GMT

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

Reply to this Message

John W. Vinson/MVP - 30 Sep 2005 18:13 GMT

>I have a record on table1 columm called userID and I would like to
> automatically insert this value into table2 columm userID2 everytime I
[quoted text clipped - 3 lines]
>
> 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

Reply to this Message