Originally Posted by
ArviLaanemets
Additional advice.
Set FamilyName of tblFamilies as unique index - then user can't enter same family name twice accidentally.
Don't use FamilyName as PK for tblFamilies. All linkings must be done through FamilyID, FamilyName must be used as visible field in combos only. This allows users to edit family names without breaking any links in DB. E.g. you have a family named as "Smiths at River Lane 12". When the family moves, you simply edit the name to e.g. "Smiths at Hill Street 44-2", and it is all you need to update.