how to reference nearly common fields

I'M NEW TO ACCESS. PLEASE BE PATIENT.

I'm setting up a club membership that contains the usual name, and address,
email, & phone number etc...

For most of the records the mailing address is the same as the home address.
I would like to set up a form where the mailing address defaults to the
home address but can be overridden to make the mailing address different.

How do I do this?

Does it make sense to create a new 'mailing address' field(s) in the table,
filled in with either a duplicate if the home address, or the new overridden
mailing address?

How do I do this even after the table has already been created and filled
in? Do I need to create another table named 'mailing addresses'. I'm not sure
what the best way to do this is.

My ultimate goal is is to easily keep track of mailing addresses when they
differ from home address, and more importantly, easily create mailing labels
with the correct mailing address.

The sample database that ships with Access called Northwind.mdb, has an
order form that does what you want. You might take a look at it and copy
that functionality.

--
Rick B



"loony" wrote in message
...
I'M NEW TO ACCESS. PLEASE BE PATIENT.

I'm setting up a club membership that contains the usual name, and
address,
email, & phone number etc...

For most of the records the mailing address is the same as the home
address.
I would like to set up a form where the mailing address defaults to the
home address but can be overridden to make the mailing address different.

How do I do this?

Does it make sense to create a new 'mailing address' field(s) in the
table,
filled in with either a duplicate if the home address, or the new
overridden
mailing address?

How do I do this even after the table has already been created and filled
in? Do I need to create another table named 'mailing addresses'. I'm not
sure
what the best way to do this is.

My ultimate goal is is to easily keep track of mailing addresses when they
differ from home address, and more importantly, easily create mailing
labels
with the correct mailing address.