Aleesha

Hmm. I can't seem to get this to work the way I would like it to. I have three events, and my three test participants have each attended some. Riker - event 1 and 2 Ranger - event 1 Elsa - event 3 When I go to the Look Up tab to learn more about Elsa's past with our organization, in the Affiliations_Activities drop down list I see all 3 possible events. For Elsa, I then selected two events she did not attend and they appeared in the Activities attended portal below. This then appeared in the Activity form as a 3, which suggests the Look Up form is creating records in the Activity form using the AffiliationID. I do not want to be able to enter information in the Look Up form. I just want to know where we last saw Elsa, so it is easier to remember our volunteers and members. I must be misunderstanding something here People and Activities_Update1.fmp12

So when I am putting contact names in the Activity form and creating entries in the Affiliations table, those relationships are not complete? I had assumed that since ContactIDs are linked to ActivityIDs in the Affiliations table, I could simply pull and display the filtered listed of ActivityIDs based on ContactID through a portal to the Affiliations table, without having to commit the record... Thank you for taking the time to explain this to me, I really appreciate it.

I see, okay. I still need to figure out what "global" means! I thought I was being proactive, oops. Is there a way for this list to auto-populate? If I understand correctly I will need to select the activities from the drop down list above to populate the table below. This is what I have been struggling with (oh, and a bunch of other things, haha)

Hi LaRetta, Thank you for your help. What was it about my portal that wasn't working? I keep looking back and forth between yours and mine and I do not see why my similar portal did not work!

Hi everyone! I am so close to completing my little database and I have one more thing I would like to be able to do. I have a "Look up" section where I can see the details of an individual. I want to do display which activities they have attended. Activities are in a separate table. People are connected to activities via the affiliation table. I am selecting people who attend an event by a portal. I just cannot get this look-up portal to work. I do not know what is wrong! Any ideas? You guys are the best People and Activities_Jul20.fmp12

Great tip, LaRetta, thank you.

This is exactly what I have been missing, thank you!

I have created an affiliation table as suggested above. I have attached a draft of the fmp here. In the Activities layout I would like to select more than one attendee at an event, creating multiple entries in the Affiliations table. Does anyone have a suggestion for how to get this to work? Thank you! People and Activities.fmp12

Ah, you have sent me down the right path, thank you.

Hello everyone, This is my first time asking for help on a board, so please be patient! I am self taught in Filemaker so far, creating field data collection solutions for use in Filemaker Go on ios. I am currently creating a new database and data collection form. Both are still in the early stages of development, and I am open to going about this in an entirely different way. Let's get started. I have two tables: One is the "People Management (PM)" and one is the Activity Management (AM)". In PM, each row is an individual who is tied to the organization, either as a volunteer, a member, donor, etc. These individuals can attend events, and we would like to know an individual's history of events attended. In AM, each row is an activity. Details of the activity, such as the location, start and end times, staff in attendance, total number of participants, etc, are stored for reporting to the funders. The names of the individuals in attendance is not necessary here. In AM data collection form, each activity will autogenerate an ActivityID# (01, 02, 03...). I would like to show up at an event and fill out this form. I imagine selecting people in attendance from a drop down list, generated by the PM table. I am capable of creating all of this just fine, up to this next point: the ActivityID from this form is, in turn, automatically placed in that participant's list of attended events. My question is: How do I achieve this last step? I imagine needing multiple columns for each individual in PM First Name | Last Name | ActivityID_1 | ActivityID_2 | ActivityID_3 .... How would I tell Filemaker to find the next empty column in the ActivityID series and fill in the ActivityID from that form I am working in? Is this possible via relationships and scripts? Is there a better way to go about this? I really appreciate your expertise. Please let me know if you need more information. Thank you