Hello
I would like to implement an assignment with Scriptcase.
I pass the category variable from another application.
Then I want to assign products to categories. (checkbox?)
I could do this with a many-to-many in scriptcase, but I still have additional fields available in my table.
In the mapping table are the following fields:
ID int(12)
product_ID int(12)
category_ID int(12)
valid_from date
valid_to date.
How can I take the from to into account when assigning.
I could query all categories by SQL in the form, and then also the fields valid_from … but how do I get this displayed to change if there are already categories that are assigned and which are not yet assigned. The plausibility check that there are no overlapping periods for the same category and product will be done afterwards.
Would be grateful for tips
Translated with www.DeepL.com/Translator