Hello all,

I am new to this board, and would appreciate some help. I have 15 fields, each with 4 to 20 checkboxes defined by a value list in another file. I need a report to show what boxes were checked (for all fields, not individual) as line items. This way I can reference the price, and then do calculations. How do I get each SELECTED checkbox into a separate line item? TIA

Cheers!

Looking at the actual data that is in the field you will see that it is nothing more than a set of items each on a seperate line. It is the checkbox formatting of a specific field on a layout that does all the magic.

Just look at the field with no formatting and you'll see what I mean.

I've used this method: make the checkboxes enter into a global field. When you first view the record, create a script that pastes all of the related values into the global field so it is "pre-loaded" with the correct selections.

After the selection (or deselection) of checkboxes, process the global field with a script that creates a related record for each new entry, and deletes related records for each entey that has been removed.

The logic behind this is reasonably easy but the devil is in the detail.

I've attached a small file that parses a paragraph-delimited list and turns it into find requests. With slight modification it can be modified to create new records.

parse.fp5.zip

Thanks for the attachment. It's just what I need!! Thanks again!

All the Best,

JohnnyZ