2nd Mailing Address

  • Thread starter Thread starter SillySally
  • Start date Start date
S

SillySally

Hi. I have some Members who are lucky enough to have
second homes and would like to alternate their mailing
addresses. There doesn't seem to be enough records
(imagine that!) to add tables, etc.

I was thinking about having a Address1Flag and
Address2Flag, with Address1, City1, State1, Zip1, etc.
I'd have the user manually "flip" the flag when the Member
indicates they are "moving". Not exactly sure what this
would look like. I'd appreciate any suggestions of how I
would code to use the correct address. This will all
distill down to mailing labels in the long run. I
appreciate the help and details are very nice.
Thanks.
 
Hi. I have some Members who are lucky enough to have
second homes and would like to alternate their mailing
addresses. There doesn't seem to be enough records
(imagine that!) to add tables, etc.
Click to expand...

One's enough.
I was thinking about having a Address1Flag and
Address2Flag, with Address1, City1, State1, Zip1, etc.
I'd have the user manually "flip" the flag when the Member
indicates they are "moving". Not exactly sure what this
would look like. I'd appreciate any suggestions of how I
would code to use the correct address. This will all
distill down to mailing labels in the long run. I
appreciate the help and details are very nice.
Thanks.
Click to expand...

Use a separate Addresses table in a one-to-many relationship to the
Members table, with a Yes/No field for CurrentAddress.

John W. Vinson[MVP]
 
Thanks for the pointers.
-----Original Message-----


One's enough.


Use a separate Addresses table in a one-to-many relationship to the
Members table, with a Yes/No field for CurrentAddress.

John W. Vinson[MVP]
.
Click to expand...
 
Back
Top