Add records to a table - but filtering records shown using query

[Heathey94]

OK, so the "AddLowRiskAssessment" Form is an example of this. I want to be able to select all of the "Behaviours" in "TblBehaviour" which follow the following criteria: Risk ID - 1, FormVersion - whatever is in a combobox which I am yet to produce, but it is likely to be a number.



Any questions/queries just ask

[orange]

FormVersion - whatever is in a combobox which I am yet to produce, but it is likely to be a number.

??????

Hopefully, you are not expecting readers to try to guess what you might develop. Is there a specific issue?
Do you have any sort of specification? Do you work from a general concept, with some mock data to familiarize yourself, then gradually add detail and specifics? It's a good approach if you really don't know what you or your users really want. A little prototyping with user feedback(interaction) is a great communication tool.

[Heathey94]

The form version is a column on the behaviour table, by that description I meant that the user would select the form version, unlike the risk ID which is pre-selected due to the fact risk ID 1 means low risk.

The specific issue is I need to select records that satisfy a criteria (as specified above) and then add the response to new rows in the assessment table (using the behaviour ID found using the above method)

Sorry I'm not great at explaining, I seem to presume too much.

[orange]

Not a problem. I'm just trying to determine what you are trying to do--generally to get some sort of context.
You have a tblFormVersions that would be the source of the combobox.
If you /user make a selection from that list to identify the FormVersionId, you can use that selection in your processing.

It might be better if you could give a brief overview of the desired processing associated with the form, and any issues with design/programming/testing that you may have or foresee.

This video may be helpful if you want to do a search base on keyword/string.

I don't mean to be jumping ahead...

[Heathey94]

I am unsure what you mean by the processing associated with the form, could you give an example?

[orange]

You have a form, The user will interact (make selections/add text/push a button..) with the form.
What is the business process involved --eg add new data to a database; update selected records to make them current; adjust recognized typos; look up data based on some keyword(s).....

Basically --the purpose or intent of the form.

[Heathey94]

Okay, so the user will check boxes, select an item from a combo box and add text (for any, or potentially all of the records which are pulled through). They then click the update button and the data is saved as new records.

I think that covers it all?