AboutJamey Key Expertise NEW and INTERMEDIATE USERS. WHAT CAN FILEMAKER PRO DO FOR ME? I have been using FileMaker products for over 10 years and have basic knowledge in all areas of FileMaker database set up and use. I`m not prepared to answer questions about complex situations or calculations but can help beginners and intermediate users set up and use FileMaker databases.
Experience Have been using FileMaker since 1989 in our business. We have 10 users on the network who use these databases every day. Our largest databases have had over 30,000 records at one time. In 1995 one of my files was chosen as "Most Unique Database" in a contest sponsored by Claris, maker of FileMaker. Recently I have developed a set of files for new computer system installed at our church.
Expert: Jamey Key Date: 4/8/2008 Subject: many-to-many relationship - show all items in other table with rel. info
Question Hi
I found a question in mid 2007 "Subject: FileMaker Relationship Troubles" that seems similar. Unfortunately the answer was a set of files you sent.
I have 3 tables. Persons, Activities and a join table. A person can be invited to an activity or not and can answer/participate in this activity or not.
My main problem. I'm viewing one person. How do I display *all* activities with status information for this particular person? (invited or not)
It is not a portal with only the activities she has been invited to.
Thanks for any help!
Answer Hello Yuan-Yuan;
So you want to display all possible activities next to a persons name? Will this list be the same for all persons?
You may want to have a "1" for each record in the PERSONS and ACTIVITIES table so all activities will show for each person. It should match up and show all activities in each persons record.
