Hi everyone
I am creating a database with the following purpose.
Questions (unique numbers) are created and are used in a flow (also has a unique name/number). A question may appear in many different flows and a flow will have a long list of question numbers (over 50)
I need to be able to find out
1. A list of questions that appear in a specific flow
2. Which flows a specific question appears in
I have read various articles about setting a list box for multiple selection and am able to do this, but am unable to link the choices to the current record (as I move from record to record the same selection remains when in 'simple' option and all disappear when in 'Extended' option.
Is there a way of getting the selected ones to link to a record, I've toyed with the idea of selecting which questions or which flows one at a time from either the question details table or the flow details table but am unsure how to get the data to collect together ie. Add to a list without overwriting and making sure it adds to the right list??
When the flow choices have been selected, when on the question detail form/table, I need the question number I am currently editing to be transferred into the flow details table so that it collects a list of question numbers that are in the flow
I've tried the suggestions on the microsoft site but have been unable to get this to work.
I hope someone out there can help
Sarah
I am creating a database with the following purpose.
Questions (unique numbers) are created and are used in a flow (also has a unique name/number). A question may appear in many different flows and a flow will have a long list of question numbers (over 50)
I need to be able to find out
1. A list of questions that appear in a specific flow
2. Which flows a specific question appears in
I have read various articles about setting a list box for multiple selection and am able to do this, but am unable to link the choices to the current record (as I move from record to record the same selection remains when in 'simple' option and all disappear when in 'Extended' option.
Is there a way of getting the selected ones to link to a record, I've toyed with the idea of selecting which questions or which flows one at a time from either the question details table or the flow details table but am unsure how to get the data to collect together ie. Add to a list without overwriting and making sure it adds to the right list??
When the flow choices have been selected, when on the question detail form/table, I need the question number I am currently editing to be transferred into the flow details table so that it collects a list of question numbers that are in the flow
I've tried the suggestions on the microsoft site but have been unable to get this to work.
I hope someone out there can help
Sarah
