Relating my databases (i'm new to FMP)

[fritztk421]

Hello-

I'm a relatively new user to File Maker Pro 4.1, but i am trying to set up a database for a specific project and i'm having a hard time getting the information i want from the users manual. Here goes...

I have three independent databases, One with general info (name, address, etc.), one with information about a specific disease, and a last one with information about a different disease. I have placed a unique ID field in each of the databases and want to be able to relate all of them to eachother. In other words, when i bring up a person's general information (name, address, etc.), I want to be able to see the information in the disease specific database that relates to their unique ID. Is this possible? Am I completely screwy? Any suggestions would help. Thanks in advance.

Fritz.

[paul]

Hello Fritz,

Hard to explain the complete process but yes its possible. Basically you need to define the relationship then display the fields in a portal using that relatioship. I have done the three databases and I'll email them to you. Any problems reply to the email

Hope this helps

Paul