469,609 Members | 1,657 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

Access 2000 form help

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!
Nov 13 '05 #1
1 1803
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.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

17 posts views Thread by chicha | last post: by
6 posts views Thread by Peter Frost | last post: by
6 posts views Thread by Peter Frost | last post: by
6 posts views Thread by Serious_Practitioner | last post: by
reply views Thread by Solution2021 | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.