Hi,
I am trying to update a column (SECURITY KEY) in one table based BY REFERENCING two other tabels. I have joined the tables. I keep getting a prompt to enter a security key when I run the update query. Does anyone know why. I am not making progress with this and have not done much with Access in the past few years. Thanks!
UPDATE (CATMAN_SURVEY_OPERATIONS INNER JOIN ARCHIVEINVENTORYALL ON CATMAN_SURVEY_OPERATION.NAME=ARCHIVEINVENTORYALL.[SURVOPS/ID]) INNER JOIN SECURITY_CHARACTERISTICS ON ARCHIVEINVENTORYALL.CLASSIFICATION=SECURITY_CHARAC TERISTICS.CLASSIFICATION SET ARCHIVEINVENTORYALL.[SECURITY KEY] = CATMAN_SURVEY_OPERATIONS.SECURITY_KEY
WHERE (((ARCHIVEINVENTORYALL![SURVOPS/ID]) LIKE CATMAN_SURVEY_OPERATION!NAME) AND ((CATMAN_SURVEY_OPERATION!SECURITY_KEY) LIKE SECURITY_CHARACTERISTICS!SECURITY_KEY) AND ((ARCHIVEINVENTORYALL!CLASSIFICATION) IS NOT NULL) AND ((ARCHIVEINVENTORYALL![SECURITY KEY])<>0) AND ((ARCHIVEINVENTORYALL![SURVOPS/ID]) IS NOT NULL) AND ((ARCIVEINVENTORYALL!CLASSIFICATION) IS NOT NULL));