Combobox linking

[aparnawangu]

Hi All,
I have a corporate form in which i am having two comboboxes named Center Name like centre1,centre2 etc.
Another combobox having name Corporate name like IBM,Accenture etc.
My query is that the two tables named Centre and Corporate having uncommon fields
like Centre having fields Centre id and Centre Name and Corporate having fields Corpid and Corpname
Problem is i cannt include any of the common field in any of the tables as corporates are tend to change but centres are steady.
Then how to connect the two comboboxes?


Pls help me out.

[ranman256]

confused.
cboCenter has the query to table tCenters
cboCorp has the query to table tCorps

What is it you need to make common between the 2 combos?
do these 2 tables need to be joined?

does picking a cboCenter need to filter cboCorp?

[aparnawangu]

Sorry for late response.
Yesi want the cboCenter to filter cboCorp but how don't know.As there is no relation between centre and corp table thats why on selecting cboCentre nothing is displayed in cboCorp.
Pls suggest that how to relate them.If joining is the solution pls let me know the procedure.