Related Records in the Same Table
Hello! I need to "connect" multiple records within the same table that have the same phone number. Each record is a customer with a membership. Sometimes a customer will have a membership and it g...
Forum Discussion
I would solve this with a different architecture. For this part of the application there would be two tables
Contacts
Memberships
RID 1 Jane Doe 501-999-9999
- RID 100 Club XYZ Mbr# 123456 Status: CXL
- RID 275 Club ABC Mbr#78910 Status: INACTIVE
- RID 650 Club XYZ Mbr#246810 Status: ACTIVE
Now when I search for a telephone number, I get the one and only Jane Doe with that telephone number and her three membership records.