OK, this is a tough one, and from what I've gathered from my previous threads on this site, may well be impossible.
I need a form to display a list of records, which are in the behaviour table (just the behaviourID and BehaviourDescription, restricted so that just those with certain RiskIDs appear - for instance, those with a RiskID of 1 appear on the LowRiskAssessment page).
I then need the BehaviourID from this record, to be used to create an entry in the TblAssessmentDetails table, along with other information the user enters on this page - "Present", "Assessment", "3rdPartyIntelligence" (all of which are tick boxes) and a comments box.
It seems entirely plausible in my head, but because I think I need the form to be based on both a table and a query - which is obviously impossible - I'm struggling to come up with how it would work.
To be abundantly clear, there is a list of behaviours, each categorised as low, medium or high. During an assessment, an assessor selects whether the behaviour was present etc. and then adds a comment. Ideally, the entry would be added even if the assessor doesn't select anything in any of the boxes, but if that is not possible, I can try to work around it.
Any suggestions would be much appreciated (although I would prefer the general layout of the form to stay the same if at all possible), and if my description doesn't make sense, just ask.