combo box that gets the corresponding value from another table

[afbutlerandassoc]

I have 2 tables - both share Ratename and Key_c;

I would like to use a combo box to search a list of ratenames and then automatically list the data from the second table that needs to be amended or changed - I can't seem to find the right data/suggestions in any info I have - please help

 

[DSummZZZ]

You can set a relation from the first table, which will be referenced by the ControlSource property of the combo, into the second table which can be the control source of a grid.

Dave S.