Including Table Name in Query Field Names

  • Thread starter Thread starter kbsmith
  • Start date Start date
K

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
 
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....
 
Back
Top