Acces 2000:
I have several 'lookup' type tables with a standard field naming
convention of id(pk) and name in a medium sized database. When I
create a select query involving 3 or 4 of these tables for example, I
have found that the alias name does not always appear as I would
expect.
For example, in the query design grid, if I use something like
ManufacturerId: id (table row shows tblManufacturer) or
ManufacturerId:tblManufacturer!id - the query runs fine, but the field
name is id.
The sql source is as I would expect: Along the lines of SELECT
tblManufacturer!id AS ManufacturerId FROM tblManufacturer...
Any input gratefully received.