jr00n

Multi key versus many-2-many

Discussion created by jr00n on Feb 24, 2014
Latest reply on Feb 26, 2014 by jr00n

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

Attachments

Outcomes