Hi,

I'm trying to find out if there is a way to get information about the Row Source, Row Source Type, Bound Column, etc, of an MS Access database, as specified in the Lookup tab for that particular column. I've looked at using OpenSchema in ADO, and also ADOX, and I can't seem to find anything which goes to this level of detail.
Basically, i'm just trying to create a generic app that will recognise a field as being a lookup table (which isn't always pointing to an actual table/query, it could be an SQL string) and get the appropriate values to display the possible valid entries.

Thanks in advance for any help. This one's been really bugging me.



-----------
Proteus3k