Access 2000 form help

  • Thread starter Thread starter Ellis
  • Start date Start date
E

Ellis

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!
 
Ellis said:
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!
Click to expand...

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.
 
Back
Top