Table/Form design; Record/user has Multiple addresses, selected the address that is the contact

Looking for advice as to the correct method of solving this design issue

I have a table for a profile / record (tblProfile), each profile can have more than one address / property (tblProp)

I have a form for adding a profile, and a seperate form to add an address.

What would be the correct method for allowing the selection of one an address as a 开发者_高级运维contact address? Would it be advisable to use a third table to store the user ID and contact address ID, or use a field in tblProp. What type of form design would be needed?

I imagine this is pretty basic database design / theory, but im having a bit of difficulty figuring this out.

Thanks in advance for any help any one may be able to provide

Cheers Noel

Having gone through this, I think that an address status field is the best bet. This will allow you to choose whether the address is the main address, a former address, etc. In fact, depending on your set-up, it can be useful to have two classification fields, the one just described and address type, which would be home, work etc.

Another point - I have found it useful in some circumstances to write the key for the main address to the persons table.