Q?

I have a textbox on a layout [Lets call it "Problems List"]. This field uses a Global field and text Option selected.

The field source for the Problems List is a Checkbox using a Related forms value list [Keep all patients common problems in another database - maintain the values for the list there].

I would like to pick and choose items from the Problems List by checking their "CheckBox".

I would like to then write a scipt to loop through the Problems List and identify the ones that are checked...

One, ?How? do I loop through this field - and Two, ?How? do I determine if the field is checked or not checked?

Is the value like a zero, or one if checked?

Later - I want to take the selected records and populate another "Selected Problems List" on this same layout with these selections... Essentially copy the selected records..

Any ideas? Thanks in advance...

Regards,

John C. Gunvaldson

San Diego, CA

If you place the same global text field on a layout, once formatted as as checkbox field and once as a normal text field, you will see that multiple checked boxes just translates into a list of items checked separated by carriage returns.

One way to perform your "Finds" is to create a relationship between the global text field and your normal field of items. Check the items you wish to find in the global checkbox display and then perform a script with the step "Go to Related Record (show only related records). MUCH, MUCH faster than a find.

The relationship is know as a "self-relationship" because it is with the same file. The global is know as a "multi-key" because it contains multiple values.

-bd

Aha,

Thanks! So I am beginning to understand the relationships I think. A global field that has been formatted to use checkboxes and a value list doesn't have individual values to each of the list items related to the checkboxes..

ie: Checking [x] on one of the list items doesn't change it's value from being a string of characters - to being a [1] or [0] and a string of characters - just creates ---> "A list of items checked separated by carriage returns"

So, I shouldnt care about the clicking of the checkbox -- just the results of the <CR> seperated values...

And use a self relation to see these values..

Ok, I'll try that this evening - and here's hoping that makes (making these selections) much more obvious...

Thanks LiveOak -bd!

John C. Gunvaldson

San Diego, CA