Hello all!
I would like to create a query from several tables, display the records on a datasheet, and be able to change values, as one would in an Excel spreadsheet.
This code only uses three table, I changed the JOINs so that I could see all the records:
This code (enter another table) is NOT updateable:
What I don't understand is why can't I update the info in one or two tables, when the fourth table is not seemingly affected. Me thinks this has something to do with how a recordset is created/designed, but is there a solution?
Thanks in advance.
I would like to create a query from several tables, display the records on a datasheet, and be able to change values, as one would in an Excel spreadsheet.
This code only uses three table, I changed the JOINs so that I could see all the records:
Code:
SELECT [T-Parts].MasterNum, [T-Parts].Item, [T-Parts].CategoryID_FK, [T-PartLocations].SummerLevel, [T-PartLocations].WinterLevel, [T-PartLocations].PartLocID, [T-PartLocations].BinID_FK, [T-Parts].Discontinued
FROM ([T-Categories] RIGHT JOIN [T-Parts] ON [T-Categories].CategoryID = [T-Parts].CategoryID_FK) LEFT JOIN [T-PartLocations] ON [T-Parts].MasterNum = [T-PartLocations].MasterID_FK;
This code (enter another table) is NOT updateable:
Code:
SELECT [T-Parts].MasterNum, [T-Parts].Item, [T-Parts].CategoryID_FK, [T-PartLocations].SummerLevel, [T-PartLocations].WinterLevel, [T-PartLocations].PartLocID, [T-PartLocations].BinID_FK, [T-Parts].Discontinued, [T-SupplierPartNums].PartNumber
FROM ([T-Categories] RIGHT JOIN ([T-Parts] LEFT JOIN [T-SupplierPartNums] ON [T-Parts].MasterNum = [T-SupplierPartNums].MasterID_FK) ON [T-Categories].CategoryID = [T-Parts].CategoryID_FK) LEFT JOIN [T-PartLocations] ON [T-Parts].MasterNum = [T-PartLocations].MasterID_FK;
What I don't understand is why can't I update the info in one or two tables, when the fourth table is not seemingly affected. Me thinks this has something to do with how a recordset is created/designed, but is there a solution?
Thanks in advance.