Getting "relationships" using VB code

[Geoff Gunson]

Hi

I have an access database with 2 tables.

Table 1 contains a field that gets all its possible values from table 2. So within access if i click on that field a combo box appears with all the options that i can select.

What I want to know is if it is possible to retrive this relationship when I open the database within VB code.

I have tried : CDRrs.Fields(FieldIndex).SourceTable

where CDRs is the open recordset but all it returns is the name of the table that the field is in. I would like to know the name of the table with all the values in.

Your is greatly appreciated.

Cheers
Geoff ;)

[VorTechS]

Sounds to me like you need to fire another query...

So on the combo1_click event, you might want to do a query with a similar SQL statement to : -

"SELECT values FROM table2 WHERE linkID = " & combo1

And then populate whatever it is you are populating using the resulting recordset.