Jump to content
Sign in to follow this  
Lizzy

solutions wanted Multiple addresses

Recommended Posts

Wondering if someone could point me in the right direction of keeping a list of addresses that my contacts have lived at. I've looked at some of the starter solutions, but they only allow for second addresses, or a business and a home address etc...

I import from excel as information is given to me, and would like to import it, have FMP find the contact, if their address in the excel spreadsheet is not the same as their existing address in our database then have FMP add the new address as a new record in a addresses table, which is linked via their ContactID...

Many thanks in advance...

:

Share this post


Link to post
Share on other sites

Easiest way would be to store addresses in a separate table, but use calc fields in the Contacts table to pull in the details from the last related address record (the rationale being that the last related record would be the newest).

Share this post


Link to post
Share on other sites

Thanks for the quick reply...

I was thinking of something along those lines for the displaying of the address in the contacts layout, but the solution I need for now is how to import multiple excel spreadsheets, so it creates records in the addresses table (but not dup's of the contact names). And then using calc's to filter the most recent address, dependent on a date field.

I've about 200 spreadsheets to import...

Sorry, my original post wasn't so clear... I'm working on an Events Database, and if we can track where people have lived, we can target them specifically in Marketing for eg: if an event in Melbourne is not full, we can email all contacts who have lived in Melbourne, and let them know there are available places... Even if a contact has moved to Sydney...

I'm thinking along these lines... Creating an Address book database that shows all our contacts, and where they have lived, and then all the addresses and who has lived there... This database is not for the end user, its just storage and related data.

In the Events database, we show the most recent address dependent on the date of the last event they attended (this way we are sure to know their address is most up to date)...

Thanks again...

Share this post


Link to post
Share on other sites

Hi Lizzy,

I am from Dunsborough - Western Australia. I would like to help you. If its ok for you send me all the spreadsheets and I will convert it in database and will send it to you.

Tusif Ahmad

Share this post


Link to post
Share on other sites

Thanks Tusif, I'm not sure the company this is for would allow that the contact lists be passed onto a third party, but I can certainly check into that some more.

I'm really just looking for assistance on the script steps, if you could help with that it would be much appreciated.

Anyway, post back your email if it's not on your profile and i'll send direct if you are interested in helping out there...

Thanks again,

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • By wedgeman
      We are working with a medical non-profit working in Latin America, running on much older hardware.  Seeking older individual or group/site license seats of FMP & FMS 13, 14, or 15.
      We need a bunch.  We could buy site license seats, or simple 1-off licenses.   
  • Who Viewed the Topic

    1 member has viewed this topic:
    enstorms 
×

Important Information

By using this site, you agree to our Terms of Use.