It's been a while... auto populate fields based on a drop down
I think the last time I played with filemaker was around 11 years ago, seems to have changed a bit since then.
I am trying to working out the best way to link some address fields based on a drop down list for location.
For example, I want the static values Birmingham, Liverpool, London, Manchester & Reading in a drop down (so user cannot add more)
When selected, the fields Street, City, Postcode, Telephone Number and Fax Number will be automatically populated with the values (again, the user cannot modify these)
I want to use this data to drive an Identity Management system (for example become an authoritive source that drives active directory) so I need to get it right, reliable but also simple.
Any help would be much appreciated.
I have made a start based on the simple Personnel demo that ships with FM http://www.4shared.com/file/lH__0_B0/Personnel_Records.html - do you think I am going about this correclty, or can it be made cleaner?
Thanks for your help and advice!