Person to address - how to keep the address as unique?

I have a table with people and an address can be added, that part I have working. What I want it to do is when you add the address I want it to give you the ability to search and find an address and associate it to the persion. (Think family units - father/mother and then children - we don't want four addresses, we want one address and then each of the parents/children can be associated to that one address.). Is there a handy way to do this ?
4 Replies
DylanBaine
DylanBaine6mo ago
When the address is assigned to a person, is it scoped to a tenet? Like only people in a specific family can be added to this address?
HeartlandTechie
HeartlandTechie6mo ago
that's the thoughts . . . . an address should be distinct, but multiple people can be associated to that address.
DylanBaine
DylanBaine6mo ago
You could do a select component and the items are addresses that belong to the tenant
HeartlandTechie
HeartlandTechie6mo ago
I also had an idea that maybe I could add a relationship to match back called "resides with" and it would tie back to the address