update table based on user selection from multi-tables

[Shawna]

Hi there,

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.
Code Description
A Blue
B Red
C Green
Code Description
1 Circle
2 Square
3 Triangle
I'd like to update a different table 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?)
Shawna