Address table design confusion

[bachgen]

Hello,

I have designed my db with an address table as a large amount of the members will be living together.

The problem I have is when entering new members how best to design/code the form. I was thinking of getting the postcode, a search returns a list of addresses with that postcode. You can then select one if it exists or add continue with the form if it does not.

I have no idea how to code this, would be greatful for some ideas.

 

[Rabbie]

You should be able to run a query against the existing Addresstable using a criteria like "addresstable.postcode = me!postcode". You could use the values returned as a basis for the new address or if no records are returned then continue with the form

 

[Banana]

If you are going to share one address with many members, I'd make this a Many-Many relationship.