Probably a simple question...

[Lougee]

And I'm not certain whether it's a RELATIONSHIPS problem or a DEFINE FIELDS problem or even it it's a problem at all. But so far I haven't been able to either puzzle it out or find the answer by searching the forum...

In a db to track attendance at a workshop, I have a summary field to calculate the number of 'yes' responses (totalAttending?). Suppose that 5 people have responded their intent to attend. How do I define/script a button that will show those 5 related records? How do I relate the total attendees with their names?

If this is right in front of my face and I'm just not seeing it, I apologize for taking up your time. But I don't see it and [color:"red"]I need help. Please.

Abbe

[falkaholic]

Assuming your database structure is 2 databases, one for workshops, and one for people. It should be fairly easy.

To count the number of people in a particular workshop that answer yes in their 'people' record is done like this:

1. make a calculation in the workshop db that does this:

WorkshopID & "-" & "Yes"

2. Then in the people database make another calc like this:

WorkshopID & "-" & AnswerField

3. Make a relation between the 2 fields from the workshop database.

4. Now make a portal in the workshop with this new relation and you'll have a list of all the people in that workshop that have "yes" in their AnswerFIeld.