Append Query Baffling Me!

[croy]

In Access 2002, under WinXP, a pretty simple append query is
giving me fits. Only two output fields are needed (for a
"join" table). When I view the query results, everything
looks perfect. But after running the query, and then
opening the target table, I see that that the data for one
of the fields has been replaced with the data from an
unwanted field!

Here's the SQL:

INSERT INTO tblGeoWix ( GeoLocId, WixConId )
SELECT tblGeoLoc_Sector.GeoLocId, tblWixCon.WixConId
FROM tblGeoLoc_Sector INNER JOIN tblWixCon ON
tblGeoLoc_Sector.SectorId = tblWixCon.Sector
ORDER BY tblGeoLoc_Sector.GeoLocId, tblWixCon.WixConId
WITH OWNERACCESS OPTION;


Instead of getting the data for WixConId, I'm getting the
data for tblWixCon.Sector.

Any help appreciated.

 

[Michel Walsh]

You may have an automatic lookup which is either translating the data (and
it is not wanted at that point), either mislead you in the field selection
you made. Can you check if ANY of the involved field has, in the table
design, for each implied table, a Lookup defined for it.


Vanderghast, Access MVP