Berlitzer

Again, Thank you very much. That information helps a ton. Thanks.

Thanks Fenton... I'm pretty sure I'm following you, I just wasn't familiar with occurences. So if data changes in the occurence, will it change in the table it represents? Could you direct me to a more elaborate (if necessary) definition of an occurence? Thank you very much.

Hello. This is my first post, and my first question. I am building a database for a small company. I have contact information that I need to record for employees, patients, and patients_other (what i call family members, guardians, etc) all of which i specifically want to keep phone and address information for. Ideally, I was trying to assign a contact_ID to each of these persons. Then the contact_ID was related to a table that contained a Phone_ID and Address_ID. Then, the address_ID related to a table that contained the address for the person. The phone_ID related to the table that contained the phone information. Needless to say, since the Patient table is related to the Patient_Other table (so i can tell what patients are associated with the Patient_others), Filemaker didn't like it because both of these tables both point to the contact table and I got the message: "There cannot be more than one relational path between any two tables in the graph. Another occurence of one of the tables must be added to the graph" Can someone explain why this is happening and what is the best way to get around it? Thanks.