Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113

    Unanswered: Query not updating & read-only

    How can I get around this? It is 6 tables involved in the query and I just need to check a box to indicate that it was acknowledged for that record.

    Thanks
    ======================
    Levent
    Access 3

  2. #2
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Get the id then up date or ....

    Hi ,

    First do your inner - left join and select the id of the row you want to update

    or

    update SET FIELD=checked From TABLE where VALUE in (YOUR Query)
    Greetz Marvels -^.^-
    Developments : VB4 Through .Net; Basic; DOS ; CNC ; Sinclair
    Databases : SQL Server Through 2005; Access 3 Through 2003 ; Oracle 8 & 9.i ;
    OS : Win 3.11 Through XP ; NortonComander ; DOS

  3. #3
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113
    This is my the query that I am running into a problem. I have attached my relationship.

    SELECT tblRqdSOP.LineID, tblRqdSOP.SOP, tblRqdSOP.Title, tblSkillSetRqd.SkillNo, tblSkillSetRqd.SopNo, tblSkillSet.SkillSetName, tblSkillDetail.EmpNo, tblEmployees.LName, tblEmployees.FName
    FROM (tblSkillSet INNER JOIN (tblEmployees INNER JOIN tblSkillDetail ON tblEmployees.EmployeeID = tblSkillDetail.EmpNo) ON tblSkillSet.LineID = tblSkillDetail.SkillNo) INNER JOIN (tblRqdSOP INNER JOIN tblSkillSetRqd ON tblRqdSOP.LineID = tblSkillSetRqd.SopNo) ON tblSkillSet.LineID = tblSkillSetRqd.SkillNo
    ORDER BY tblRqdSOP.SOP;
    Attached Thumbnails Attached Thumbnails relationship.JPG  
    ======================
    Levent
    Access 3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •