List passing value to another list on a single form 1

[ovs8]

Hi there,

I'm trying to put 2 lists on a single form. Lists grab their data from the 2 separate tables which are linked (1-many)

I would like to select a value in the 1st list and pass it on the 2nd list to get a corresponding list of values from table 2.

How do I do that?

thank you,
oleg

 

[Eupher]

Have a look at the following FAQ's:

faq702-4289
faq702-4640
faq702-681

They deal with combo boxes, but the principle is the same.

HTH,

Ken S.