checkboxes or similar

[Fraudie]

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.

[Vaughan]

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.

[Fraudie]

Ok yea that makes sense

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

[Søren Dyhr]

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

[Søren Dyhr]

Here's a more interface centric approach...

--sd

Attendance.zip

[Fraudie]

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.