4 Replies Latest reply on Jan 9, 2008 7:06 AM by lockjaw8y9

    Restrict Many to Many detail table

    lockjaw8y9 Level 1
      I'd like to be able to restrict the detail table in a Many to Many update. In this case, there are some items in the detail table that do not belong to the customer, so they should not be available in the many to many display. I can create the proper recordset (SELECT * FROM detail WHERE detail.owner = $_SESSION['kt_login_id'] OR detail.share = 'Y'), but due to the LEFT JOIN that the many-to-many uses, I get all of the records in the detail list when I use the wizard. Everything else is PERFECT, so am I out of luck here, or is there hope? When I try to modify the many to many generated recordset manually, the display of records in the browser is correct, but the records no longer update correctly when I try to submit the changes.