A cross-relationship table would do here.
Each record of Crosstable holds the IDs related records a foreign keys:
Contacts::ID <-> Crosstable::fk_Contacts
Crosstable::fk_Software <-> Software::ID
Now you can display for a given SW record the related contact data and vice versa.
+1 to Torsten. Cross relationship table is also know as a Join Table. I would also recommend this if you coming from a general DBA background. Here is the FileMaker KB link:
The other approach is FileMaker specific. Instead of Using 10 foreign key fields in Software table to record related contacts you can use a single indexed text field and add contact ids as a value to a list (CR delimited):
If you link to this field e.g. contacts::id = Software::contacts_IDs, you should be able to see all software records from contacts contents. As far as I remember it is called multi-key field relationship (unless I made it up).
I am a super noob and I understand there is a place to enter in the calculation and information you have posted, but don't have the experience of knowing what to do with the information your provided me. Nicolai also provided you with a 1+ so im going to assume it is correct and I am going to spend the next couple hours watching videos and reading the KB article and hopefully will understand your response very shortly. I will post back about 8pm est to confirm if this helped. Thanks in advanced
Torsten, You are correct I was interested in join table and Since I am still new to this I did not fully understand your answer. if you have time to better explain your answer for noobs like me that would be great because to grasp the concept of join table, I had to watch the attached video about 10 times to fully understand the logic in how relationships and filemaker work to create the desired effect i was looking for. After learning about the join table I now understand your response, So i thank you very much for helping me and I wish I could give nicolai some points because his post was also very helpful by providing the useful kb link.
The video that helped me solve this problem the most: Click Here.