Hey guys,

I'm making a private database for a meeting which has members and then attendance tables. In the members tables i have multiple names become the members can be considered more as families.

In the attendance table i select the member ID which then brings up all the names of the family. I want to have checkboxes next to all these names so i can identify which people from the family actually came. any way to do this which could possibly be used in a find script? if not doesnt matter im mostly looking just for a checkbox so i can identify which individuals came from the member group...

Cheers,

Simon.

I'd have one table for "Memberships" and another for "People" where multiple People can have the same Membership.

Instead of checkboxes, use portals to display members and people.

Ok yea that makes sense

But how would i determine which individuals came from the member group??

Either by a recursive many many tablestructure, or slightly simpler make a subsummary report this way, sorting on an extra attribute "family".

--sd

stats.zip

Here's a more interface centric approach...

--sd

Attendance.zip

Thanks sd,

This way surpasses my knowledge in filemaker.

No way i could have worked that out myself from looking at it haha.

Cheers,

Simon.