Thanks Bob.
The reason I chose to put all of the tasks into the Shows table as separate fields was to facilitate data entry, and because at the time it seemed like that was the only way to do it effectively.
I think your first scenario is the better choice, I'm just not sure how to set...
I have a table, Shows, which is a checklist for the tasks that need to be completed for each show date. In the shows table, there are several different tasks being tracked and each task has 3 fields (Status, Date, Remarks). For instance the following 3 fields track whether or not the contract...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.