OK...
I have been working on this observational database for awhile now, and have run into another hurdle.
I am trying to get a 'checklist' to show up.
This is how I've set things up:
There are tblchecklistname, tblchecklist, and tblchecklistdetail table. The tblchecklistname contains 2 fields: checklistname and checklistnameid. tblChecklist contains 5 fields: checklistid, observationdetailid (points to observationdetail table), categoryid, behaviorid, and checklistnameid. TblChecklistDetail contains 4 fields: checklistdetailsid, checklistid, ratingid, and reason.
The user creates a checklist using a form, and the data is stored in the checklist table. Checklists contain categories and behaviors (to be observed). The checklistname table allows for the user to create more than one checklist.
The user needs to input observational data. That data consists of a list of set behaviors (to be used for several observations), each with individual ratings (hence, the checklistdetails table).
Now the problem:
On the data entry screen, there is a listbox of the checklist names. I want the user to be able to select the name of (previously designed) the checklist they used during observation. Then there is a subform on the form, based on a query that selects the observationdetailid, categoryid, and behaviorid for tblchecklist, and the ratingid and reason from tblChecklistDetails (in order to get an individual rating for each behavior). Now, I want that subform to populate the list after the name of the checklist is chosen in the listbox. I figure I need an append query, but confused when I realized I wanted to append to the same table.
I figured that this was hard to follow, so I attached my work in progress.
The forms to pay attention to are frmObservationDetails and sfrmObservationChecklist <--these are the ones I am working on
Other forms to look out, for a little FYI, would be frmChecklistSetup and sfrmChecklist <--this is where the user defines things
To anyone willing to take a look at this and help me: Thank you so much.
I have been working on this observational database for awhile now, and have run into another hurdle.
I am trying to get a 'checklist' to show up.
This is how I've set things up:
There are tblchecklistname, tblchecklist, and tblchecklistdetail table. The tblchecklistname contains 2 fields: checklistname and checklistnameid. tblChecklist contains 5 fields: checklistid, observationdetailid (points to observationdetail table), categoryid, behaviorid, and checklistnameid. TblChecklistDetail contains 4 fields: checklistdetailsid, checklistid, ratingid, and reason.
The user creates a checklist using a form, and the data is stored in the checklist table. Checklists contain categories and behaviors (to be observed). The checklistname table allows for the user to create more than one checklist.
The user needs to input observational data. That data consists of a list of set behaviors (to be used for several observations), each with individual ratings (hence, the checklistdetails table).
Now the problem:
On the data entry screen, there is a listbox of the checklist names. I want the user to be able to select the name of (previously designed) the checklist they used during observation. Then there is a subform on the form, based on a query that selects the observationdetailid, categoryid, and behaviorid for tblchecklist, and the ratingid and reason from tblChecklistDetails (in order to get an individual rating for each behavior). Now, I want that subform to populate the list after the name of the checklist is chosen in the listbox. I figure I need an append query, but confused when I realized I wanted to append to the same table.
I figured that this was hard to follow, so I attached my work in progress.
The forms to pay attention to are frmObservationDetails and sfrmObservationChecklist <--these are the ones I am working on
Other forms to look out, for a little FYI, would be frmChecklistSetup and sfrmChecklist <--this is where the user defines things
To anyone willing to take a look at this and help me: Thank you so much.