Hi,
We have three tables, order, orderrows and article. We create a record in the order table. The next step is to go to the article table and select 0 to unlimited articles (user selects articles). For each article in this selection we should create an orderrow.
What is the best practice to do this?
Anton Dorrestijn
for now you have to use a valuelist for this with as type CHECKS. So that you can select the articles you want.
In the next release we will have row ‘globals’ or in mem row variables that you can use for that.. (every row has a extra column that is not stored in the db but can be used for things like you want, then these kind of things will be much easier..)
Hi Johan,
The article table contains 10.000+ rows, I don’t think a valuelist is a valid sollution. Is there another approch to this problem?
Anton
The other thing to do is place a “add” button on each row. so that the selection immediantly add it to the set.
(and you can make the button text select or deselect depending if the article already is in the set)
So don’t wait for a total selection but do the select directly (the user doesn’t have to notice this)