Extract part of address from address field
Can I extract data from an address field so that I can format the address when printing it on a letter? Example Address field: 3300 North Brook Place, Boise, ID 83710 United States ...
Forum Discussion
Thanks.
I found the address fields you described. But I have encountered a new problem.
The address I want to format (a customer contact address) is in the "Proposals" table.
The address in the Proposals table is a lookup to the "Customer Contacts" table.
The address in the "Customer Contacts" table is a lookup to the "Site List" table.
What is the best way to do this? Should I format the address in the "Site List" table then carry the formatted text through to the "Proposals" table as a lookup?
I found the address fields you described. But I have encountered a new problem.
The address I want to format (a customer contact address) is in the "Proposals" table.
The address in the Proposals table is a lookup to the "Customer Contacts" table.
The address in the "Customer Contacts" table is a lookup to the "Site List" table.
What is the best way to do this? Should I format the address in the "Site List" table then carry the formatted text through to the "Proposals" table as a lookup?