So I am wrestling with an idea and can't figure out how to set up my relationships to get it to work. I am little dyslexic and find myself rethinking the same stuff over and over again (and not getting anywhere). Attached is my relationships diagram. Every table I have is included. What I am trying to accomplish is this:
There is a checklist, which the user will have control adding and editing categories, and behaviors under those categories on a checklist. There is only one checklist.
Observational data will be collected. I will have a form, with the main form based on the observationdetail table and the subform based on the checklist table. I want the main form to contain a bunch of drop down menus where the user defines what goes in those menus in different forms (this isn't part of the problem). Then I want the subform to list all the BEHAVIORS (not categories) with a spot to rate them and provide a reason. Also attached is a picture of how I want the data entry screen to look and the checklist edit screen. The only difference is that there will be only one checklist, users will not have the ability to create a new checklist.
I feel like there is a problem with my tables and this will not work based on what I have now. I wanted to be able to define a relationship between the checklistID on the observationDetail table and checkList table, with a one-to-many relationship (ObservationDetailID-to-CheckListID, backwards from what Access wanted to do) and the relationship is indeterminate.
How could I get something like this to work? It's a hurdle to wrap my brain around this.
There is a checklist, which the user will have control adding and editing categories, and behaviors under those categories on a checklist. There is only one checklist.
Observational data will be collected. I will have a form, with the main form based on the observationdetail table and the subform based on the checklist table. I want the main form to contain a bunch of drop down menus where the user defines what goes in those menus in different forms (this isn't part of the problem). Then I want the subform to list all the BEHAVIORS (not categories) with a spot to rate them and provide a reason. Also attached is a picture of how I want the data entry screen to look and the checklist edit screen. The only difference is that there will be only one checklist, users will not have the ability to create a new checklist.
I feel like there is a problem with my tables and this will not work based on what I have now. I wanted to be able to define a relationship between the checklistID on the observationDetail table and checkList table, with a one-to-many relationship (ObservationDetailID-to-CheckListID, backwards from what Access wanted to do) and the relationship is indeterminate.
How could I get something like this to work? It's a hurdle to wrap my brain around this.
