Including Table Name in Query Field Names

[kbsmith]

Hi all:

This might be a foolishly simple question, but I was wondering if there is a
way to get Access to include the name of the table a given query field comes
from in the name of each query field in datasheet view.

I know that when you have two identically named fields from different tables
in a single query, Access will display the field names as TblName.FldName but
can this be set as the default behavior for every field name in the query?

Thanks for your help!

-Kevin

 

[Duane Hookom]

I doubt there is any setting or option that can do this. I generally use a
naming convention that results in no duplicate field names in an mdb. For
example:

tblEmployees
===============
empEmpID PK
empLastName
empFirstname
empDptID links to tblDepartments.dptDptID

tblDepartments
dptDptID PK
dptTitle
dpt....