Building data in field based on.....

[Shawna]

Hi there,

I have a number of tables (16) which are all 2 fields,
code & description. Is there a way for me to allow the
user to choose the description from the table and based
on the description chosen use the associated code to
build the results into a fields in a different table.

i.e table 1
Code Description
A Blue
B Red
C Green

table 2
Code Description
1 Circle
2 Square
3 Triangle

If the user chooses Red from tbl1 and Circle from tbl 2,
I'd like to update a different table with

Code Description
B1 Red Circle

Of course keeping in mind I have 16 tables to work with.
(Not all would be applicable at once though based on the
first item the user chooses it would enable choices from
i.e. only 6 of the other tables, How best would I display
these tables to the user?)

Anyone out there who can help....Thank you in advance
Shawna

 

[Guest]

-----Original Message-----
Hi there,

I have a number of tables (16) which are all 2 fields,
code & description. Is there a way for me to allow the
user to choose the description from the table and based
on the description chosen use the associated code to
build the results into a fields in a different table.

i.e table 1
Code Description
A Blue
B Red
C Green

table 2
Code Description
1 Circle
2 Square
3 Triangle

If the user chooses Red from tbl1 and Circle from tbl 2,
I'd like to update a different table with

Code Description
B1 Red Circle

Of course keeping in mind I have 16 tables to work with.
(Not all would be applicable at once though based on the
first item the user chooses it would enable choices from
i.e. only 6 of the other tables, How best would I display
these tables to the user?)

Anyone out there who can help....Thank you in advance
Shawna
.

I would use a combo box whose data source I would set as a
query based on the supporting tables that you want to
use. You could make up the query using two columns, the
first would be the bound column, the code, the second is
just a descriptor. Thus in the form, table you want to
save the data, there would be a dropdown list which would
then store the code you are describing.