Enter Data from one Access table to another without retyping

J

JudeFowey

Can anyone help me with the following. I have a Contacts Table with the usual
name and address columns but I also have a Shipping Address Table that I want
to be able to put the Contacts details into. Majority of the time the
shipping address is the same as the Contact. Is there a way that I do not
have to retype the information for the ones that are the same?

Please help!!

Thanks

Jude
 
D

DL

You mean you want to duplicate data in two tables? not a good idea, its
against fundamental db design principals.
You use a key in the tables to form a relationship between the two
eg ContactID in Contacts tbl links to ContactID in Shipping
 
D

dlw

make a form to enter the data, on the shipping address field, in On Enter in
the event properties, point to this macro:

Setvalue
item = [forms]![entryformname]![shiptoaddress]
expression = [forms]![entryformname]![billtoaddress]
 
U

ukredskin

BUT, when I enter the data into the ContactID field in the Contacts tbl is
there a way to put that same ContactID data into the ContactID field in the
Shipping tbl without having to re-type it?
 
Top