(I am fairly sure of my diagnostics/conclusions below)
I had a simple form which shows information from 3 tables.
(i..e A MASTER table and 2 joins )
The form has been working fine for weeks but today I added a fourth table (1 field only)
When I added the 4th table my form gave the "Recordset is not updateable message".
I cannot update my table anymore ! Help!
When I remove the 4th table the form fails too as it seems to have lost most of its data (excuse the vagueness)
See code below.
Any thoughts appreciated.
SELECT MASTER.Updates, MASTER.ID, MASTER.COMMENTS, MASTER.LOCATION, MASTER.FILE_BAR, MASTER.FIRST_NAME, MASTER.SURNAME, MASTER.Long_string, MASTER.ADD1, MASTER.ADD2, MASTER.ADD3, MASTER.ADD4, MASTER.SURNAME_2, MASTER.FIRST_NAME_2, MASTER.SURNAME_3, MASTER.FIRST_NAME_3, MASTER.BU_NAME, MASTER.BU_CODE, MASTER.FILE_TYPE, MASTER.FILE_NUM, MASTER.ACTION_1, [BU Names].[Business Unit], MASTER.Last_updated_by, MASTER.SCV_Number, MASTER.NOTES, ALL_fs.Field2 AS [FS Status], Files_Moved_During_Closures.From_To
FROM ((MASTER LEFT JOIN [BU Names] ON MASTER.BU_CODE = [BU Names].BU) LEFT JOIN ALL_fs ON MASTER.FILE_BAR = ALL_fs.Barcode) LEFT JOIN Files_Moved_During_Closures ON MASTER.FILE_BAR = Files_Moved_During_Closures.barcode;