J
Jody
Hi All,
A subscriber can have many addresses. Can anyone suggest the code to duplicate a record in the address table with the exception of the primary key value Address ID (of course) and a substitute value in a foreign key field - SubcriberID. I have an address for one subscriber that I'd like to clone or 'auto-fill' for another subscriber who lives at the same address.
When a second Subscriber ID is selected from a combo field as part of the first Subscriber record, the after update would execute this code. An alias of the subscriber table is related to the subscriber table.
Thanks,
Jody
A subscriber can have many addresses. Can anyone suggest the code to duplicate a record in the address table with the exception of the primary key value Address ID (of course) and a substitute value in a foreign key field - SubcriberID. I have an address for one subscriber that I'd like to clone or 'auto-fill' for another subscriber who lives at the same address.
When a second Subscriber ID is selected from a combo field as part of the first Subscriber record, the after update would execute this code. An alias of the subscriber table is related to the subscriber table.
Thanks,
Jody