I have a simple query which joins 2 tables by their telephone numbers. If the telephone numbers are the same, it copies the [Architect].[AIA-ID] field in table 2 (which is an AutoNumber field) into the 2nd table, [1Firms-ADD New to Firms On Project].[ArchID] field (which is NOT an AutoNumber field).
What's confusing is that the 2nd table is not always updated, when the (2) telephone numbers are the same. So the question is why do some of the records update and some don't when the telephone numbers are identical?
Thanks in advance for any suggestion
What's confusing is that the 2nd table is not always updated, when the (2) telephone numbers are the same. So the question is why do some of the records update and some don't when the telephone numbers are identical?
Thanks in advance for any suggestion