Log In    |    Knowledge Base    |    4D Home
Tech Note: Linking Multiple Addresses to Multiple Tables
Published On: August 31, 2001
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

Early contact databases usually had a fixed number of fields defined to store a single address. Later, many databases were modified to store perhaps two addresses per contact record (often a billing and shipping address).

Today it is common for a contact to perhaps have more than one address, for example it is common in the USA to have both a mailing address and a physical address. Some individuals may also have addresses that are valid at different times (home, college etc.).

This technical note explains a simple method for attaching multiple addresses to a contact record. It can also be used to allow the address table to be linked to multiple contact type tables in a database. The code and form objects can easily be copied and pasted to new forms and form methods as they are defined.

Download Complete Tech Note & Example: Windows | Mac