L
loony
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.
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.