How do I display multiple ID info on same record in relational database?

[seattleflo]

Hi everyone,

Thanks for helping me out with this one...

O.K. I have two fmp databases.

1. Software: Contains all information regarding software titles. Each software title has a unique ID listed in the field (software id).

2. Client: Contains all of the client cpu information. Each client has a unique ID listed in the field (client id).

In the software database, what I would like to do is create a relationship where I can list all of the clients from the client database who are using a specific software on the same record as the software title.

In the client database, I would like to list in each client record, all of the software titles the user has installed.

I was hoping there would be a way to do this by associating/listing the software and client ids in each respective database, then creating a portal for the other info (version, client name, etc).

What I am finding is that if I establish a portal relationship and use software id to list of all of the titles in a user record, I can't list more than one title, because the previous result is overwritten with the new id info.

How can I do this?

I have attached sample pdfs that represent what what I would like to do...

Thank you so much.

Seattleflo

client_listing_software.pdf

software_listing_clients.pdf

[aaa]

Helo, seattleflo .

Read about many to many relationships.

You must have third file which joins your Software and Client databases.

This join file let his be Software_Client must contain:

Software_Id

Client_Id

fields

Now you must creat relation frome files Software and Client to this file by ID.

Try, if you can't i can atach example.

[seattleflo]

Thanks so much...

I mostly get it...I think.

However, I am having difficulty with the calculation fields.

If there is any way you could post an example to help me understand that 3rd database, I would be soooooooo appreciative.

Thanks.

Seattleflo

[seattleflo]

I got it!

Finally figured it out, based on your suggestions...

Thanks so much for your help.

I really appreciate it.

SeattleFlo

(=