Do you really need the Households table?
Would this also work or do you need to list multiple addresses for the same People record?
People::_fkAddressID = Addresses::__pkAddressID
For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained
Also, please note that the fact that you have tables that are from other Filemaker files is a more complicated way to set this up than to have all your tables in the same file.
Thanks for your reply. Maybe I don't need the Households table? I was basing that on an example I saw online, but now that you mention it I could probably do away with that.
To determine if you need it or not, you have to answer this question:
Will a given record in People ever need to link to more than one record in Addresses?
If the answer is yes, you need the Households table. If the answer is No, you do not.
In some contact managers you need to store multiple addresses for an individual such as a shipping vs. a billing address. Other contact managers have no such need for linking a People record to multiple addresses.