Ellis wrote:
I have created a form in Access with several controls that have drop
downs for the user to choose. I now need to create a record in the
table for every combination (eg. one option in a drop down menu means
7 outcomes, and one option in another drop down menu means 3 options,
for a total possible outcomes of 21).
Can someone please help guide me to accomplish this.
Thanks!
This might put you on track to doing it the way you want.
Create a test table (Table1) and create 7 records; enter the number 1-7.
Create another test table (Table2) and create 3 records; enter A-C.
Now create a query and add table1 and table2. Drag down the fields from
both tables. Now run the query. You should have 21 records.
This is called a Cartesian join. You can apply this concept to your
problem.