4-03-06 02:10 PM - Post#200710 In response to alphanitrate Hi alphanitrate, You would use an Auto-Enter on Field 1 (be sure to UNCHECK 'Do Not Replace Existing Value' with: If ( Categor - Relationships

June 20, 200718 yr

4-03-06 02:10 PM - Post#200710

In response to alphanitrate

Hi alphanitrate,

You would use an Auto-Enter on Field 1 (be sure to UNCHECK 'Do Not Replace Existing Value' with:

If ( Category = 200 ; "yourCheckboxValue" )

... where yourCheckboxValue is whatever is specified in that checkbox value list. But does that Value List contain other values as well? If so, change the calc to:

If ( Category = 200 ; "yourCheckboxValue" ; Field 1 )

It helps to have specific examples. The first example assumes only one value - it becomes a toggle and will only allow a one value or blank. The second example allows multiple values.

LaRetta

Hi alphanitrate,

LaRetta has provide a similar answer as I was going to post, but she beat me to the punch because she is a faster typist then me.

However, I was going to ask a question to clarify the answer a bit:

is the Category = 200 the only number you want this fore, or were you talking about the range of 200...300, i.e. 200, 201, 202, ... 299?

HTH

Lee

I thank you both for providing me help before - and i am looking for it again.

Here's the scenario - I have a list of product catagories ( 200, 300, 400 etc) i would like these catagories to activate check boxes that correspond to safety warnings. ( IE. 200 = don't eat)

Now some catagories may have multiple warnings. ( 300= don't eat, keep out of light, explosive.)

So in my layout the items would be have check boxes for all the possible warnings, but would have some prepopulated based on catagory.

I would also like to have the new checked off warnings attached to this record, but not the whole class.

Here's what i've done so far:

Set up a Checkbox set linking the catagory number from another file and the field (:BYRNUM).