I have a table of Sessions. Each session can occur or not, in each of 12 working weeks (the same session can be repeated in multiple weeks). To represent this I have a related table of "Session Occurances" with fields SessionID and Week. The presence of a record in this table indicates that the session occurs in that week.
The existing system used is an Excel sheet in which each session is a row; there are 12 columns, one per week; and an "x" in a week column means that the session takes place in that week.
How can I recreate this in FileMaker - probably with tick boxes instead of x's in columns - so that there are 12 columns in a table which indicate the presence or absence of a SessionOccurance record for that session and week, and which create or remove those records when ticked or unticked?