4 Replies Latest reply on Feb 26, 2014 9:13 PM by jr00n

    Multi key versus many-2-many

      Hi,

       

      I’m looking for a way to make a selection on a checkbox set. I

      If the checkbox is checked it must generate or delete a record in a N->M relation, the join table "CategorieSelectie".

       

      I could also with a multikey value in Project and don't use a join table.

      I have never had experience with multi-key field, but no idea ho to do it else.

       

      I’have no idea where to start because the layout must be based on a table, but which one?

      And the checkbox set is 1 field with checkmarks based on the fact if there is a record for that project and that particular code.

      The value list is a calculated field of a concat of: sfbcode ¶ “ : “ ¶ Onderdeel

      But on what field must the checkbox set being defined?

      I guess there is a script involed to determine a add or delete of a record based on the checkmark….clueless…

       

      Any suggestions? That would be great…Thanks.

       

      Regards,

       

      jr00n