There's a lot of detail missing there. That makes it hard to picture what exactly you are doing and why.
If you take a look at the scripted conditional value list example in the following file, you'll find a working example that seems similar to what you describe here. It performs a find, then gets a list of values from the found set where you can just get the list from the check box field, but the way the value list is set up would seem the same as it lists values from a single field in a single record.
- Make relation with checkbox = supplier table::field used in "all suppliers value list" for the check box (if there is already connection between tables, you need duplication of supplier table for right side)
- Make value list from the supplier table using "only related value" option
I have a checkbox field on the page. I want to make a drop down list containing only the items selected in that checkbox field. The checkbox field is unique to every record.
If you check the adventure file the example I mentioned does exactly that.
The main thing is a self join that matches by primary key. This matches the current record to itself so that your typical relationship based CVL setup only lists values from the current record.
The other key detail is that when you use a field that contains a list of values--such as that produced by your check boxes, as the source for a value list, each value becomes a separate value in the list.
I went through the Adventure File, but I became rather confused as to how any of it would help me. I made a self join of the "availability" to " NewInvoiceSeller"... I still do not understand how I will be able to make a value list of just the checked boxes still. I do understand that all the checked boxes are singular items within the field of the record. But I couldn't find out in the file how to modify by script to just make the value list equal to the field either.
You aren't matching records by primary key. They need to match by ID so that a record only matches to itself.
Assuming that your your layout is based on ProductsCategory, you set up a use values from field value list that lists values from ProductsCategory2. Select your check box field as the first field. Select Include Only Related Values Starting From ProductsCategory.
Ok. That makes a lot more sense, after decoding it for about 5 minutes; so now that field works exactly as I was wanting it to. Thank you.