Extracting table name from fields in a query 1

[BasicBoy]

I am joining a few tables of which some have similar field names like say ID.

When I open the DAO recordset, I have field names, but I wish to know from which tables those fields were extracted.
Is there a way to establish that from the fields or other collection.

For instance I would like to have the tablename.fieldname for a specific field in the recordset

Thanks

 

[strongm]

Fields in DAO have a .SourceTable property

 

[BasicBoy]

If I may ask another question on this

What if a specific field is a product of two other fields - and can therefore not be updated - and does not have only one source table - can that be established ?

I mean - even if it is a product of two other fields from the same table - can it be established if this field has been calculated or if it is an original field of the table.

Thanks

 

[strongm]

>two other fields ... and does not have only one source table

Sadly not