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