I would like to create a subform with 3 columns.
1st column should list of about 20 time intervals which is fixed
2nd column should be dropdown/combobox with tasks that the user can choose for each time interval
3rd column should be dropdown/combobox with teamnames that the user can choose for each task
So for example, in a row, you should see a time interval i.e 8:15-8.30 with Task1 and Team A
How can I create such a subform?
This subform needs to be in a mainform with Username and Current date, so the records input should be unique for each user and each date.
I have tried to build a separate table for timeinterval, task and team and link them together with an input table using a Query but the timeinterval doesn't list up.
Would highly appreciate any help and advice as soon as possible as I need to deliver this project within a few hours.
THAAAAANKKKSSSS!!!
1st column should list of about 20 time intervals which is fixed
2nd column should be dropdown/combobox with tasks that the user can choose for each time interval
3rd column should be dropdown/combobox with teamnames that the user can choose for each task
So for example, in a row, you should see a time interval i.e 8:15-8.30 with Task1 and Team A
How can I create such a subform?
This subform needs to be in a mainform with Username and Current date, so the records input should be unique for each user and each date.
I have tried to build a separate table for timeinterval, task and team and link them together with an input table using a Query but the timeinterval doesn't list up.
Would highly appreciate any help and advice as soon as possible as I need to deliver this project within a few hours.
THAAAAANKKKSSSS!!!
