Efficient invitations and attendance tracking (Multi Select Control?)
Hello, I am new to FileMaker, but I have worked with databases before. I have several tables.
I have two layouts that are driven by three tables each that needs some help.
Invitations and attendance layout
This layout is to allow a meeting planner to quickly mark off participants as invited and/or attended to an event. I have a participants table to track all potential invitees and a meetings table to track the various events.
Intersecting these two table (Participants and Meetings) is a table called MeetingParticipants.
The meeting table has event pertinent fields. The participants table has fields that contain an individuals personal attributes. The intersection table meetingparticipants has information like invited, attended, reimbursed, etc.
What is the best way in FileMaker to allow a meeting planner to select a meeting, quickly checkoff or indicate that 100 people have been invited.... (by name) then later go back and indicate that 50 of them showed up? I had a hunch that some type of multi select listbox should do the trick....
Invoices and Invoice History layout
I believe my other layout is solvable with tabs and portals... Invoices which matches participants, meetings, meetingparticipants, and has a document history. So while I toil away trying to fix my invited/attended issue above I am also preparing a plan for the final other step that lies ahead... I appreciate any assistance.
Thank you, Arman Barsamian