Tracing dataset fields back to table field information

[Siegfried Heintze]

ADOX and, (I just learned) DAO have lots of metainformation on the fields.
For example, I can determine if a field is a foreign key.

When I use C#/Visual Studio.NET to create a Dataset generated by a SQL
select statement, I can get some metainformation about each of the result
fields. When I enumerate the metainformation in the dataset, it is not as
rich as the metainformation in ADOX. For example, the Dataset won't tell me
if a certain field is a foreign key.

When I enuerate the fields in a populated dataset, how can I determine which
table field the dataset field came from without writing my own SQL parser?

Thanks,
Siegfried