Dynamic toggle buttons to control values in a single table
I will try and keep this as succinct and to the point as I can, more for my own sanity and to save me getting confused and ultimately rambling.
I am trying to create what is essentially a sort of diary system in Access (2016). I know this isn't ideal and I should probably explore some sort of integration with Outlook but for now I'd like to contain it all within Access.
There are 230 countries attending a single event taking place across one day. There are timeslots within this single day that any country can attend from 0600 to midnight. The timeslots are 10 minutes each and a maximum of three countries can attend any one slot.
I have a form that records other ancillary information that isn't important here. This form is dynamic in that it pulls the country value through from a previous selection screen. I am trying to build an Open Table type timeslot selection screen which is essentially a grid with toggle buttons to represent times. These go green when they're clicked and the county value is stored into a textbox which I was going to link back to the timeslot table.
From here I am a little stuck. I am not sure how I should go about recording this in the table. Could it be that the toggle looks for the stored country value and then scans the table for the matching country value and then enters a value into the correct timeslot?
Another issue is then how the timeslots look when opening the form. The ones that have been pressed will need to stay pressed (and green). I guess first things first though (code a little, test a lot etc).
Thank you for any and all help on this.