BrenoAguiar
IS-IT--Management
I have a form that it has been working fine to ADD data to the table "cleanup". BUt if by mistake the user types something over the field "computercode", it will mess up another table "units" that it should NOT! here is the SQL:
SELECT Cleanup.ComputerCode, Cleanup.UnitCurrentGrade, Cleanup.UnitpreviousGrade, Units.BuildingID
FROM Cleanup INNER JOIN Units ON Cleanup.ComputerCode = Units.ComputerCode;
Is there a way that If the User Edit the "computercode" field, it will only change the "cleanup" table?
Thanks a lot!
SELECT Cleanup.ComputerCode, Cleanup.UnitCurrentGrade, Cleanup.UnitpreviousGrade, Units.BuildingID
FROM Cleanup INNER JOIN Units ON Cleanup.ComputerCode = Units.ComputerCode;
Is there a way that If the User Edit the "computercode" field, it will only change the "cleanup" table?
Thanks a lot!