Populate Mailing Address Fields based on user selection

[streamranger]

I want to populate a set of mailing address fields based on user selection of which address to use

I have a relational database with three main tables: Property, Project and Permit. Each property may have multiple projects and each project may have multiple permits. The property table has the owner address, the permit database has an applicant address and a contractor address.

the mailing address selection field [ESCltr_2015_Address] has "owner", "applicant" and "contractor" as choices in the drop-down field.

What is the best way to populate the mailing address fields (e.g. [Mail_FName], [Mail_LName], etc) based on the selection field?

 

[pbaldy]

I just did something similar for a client. I created a VBA function that accepted the selection as an input and returned the desired address. It also accepted the key fields necessary to get the address, in your case a property ID or something. Within the function it built SQL appropriate to the selection, opened a recordset on that SQL and returned the info found.