NB - just realised I posted my query in the wrong section (I think) - many apologies for doubling up....

Hello,

I have a 'wish list' field and an 'actual' field containing multiple items (could be check boxes or radio buttons). These use the same value list. I'm trying to create a 'pending' field to automatically show me the 'wishes' that aren't yet 'actual' but can only get a blank field.

Thought I could have an auto-enter calculation to say 'wish - actual = pending', but (of course!) its not working.

I'd really appreciate any help anyone out there can give.

Many thanks in advance,

Holly

FileMaker Version: 5

Platform: Windows XP

When checkboxes and radio buttons are used, filemaker stores each item on a separate line in the field. You can see this by putting a copy of the field on the same layout, set its style to Standard Field then watch what happens when you check/uncheck boxes.

So, you might be better off with a script. I've attached one that does this. Basically, it loops through all the values in fieldA. For each value, if it does not exist in fieldB, it appends it to fieldC.

I wrote it in v6.0, but I don't think it uses any functions that don't work in 5. Let me know if anything strange happens.

Jeff

Oops, here.