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

Hi Holly. Starting your wish list already?

This looks pretty tricky. I think it could be done in a calculation if the value list is small and isn't likely to grow. Or a script if you have many values or a more dynamic value list.

Either way is pretty complex. Involves checking for each value of Actual in Wish List and concatenating non-matches as the result.

Maybe someone has an elegant solution.

I've built a system that does this. It's two portals side by side like the Sort dialog box. Click on an item and it moves across to the other side, so one side shows what;s available and the other what's selected.

It's complicated. The value lists need to be based on records in another file. I have attached a demo file.

FileMaker Version: 7

Platform: Mac OS X Jaguar

List.zip

Sharing little secrets then...

I had this one in a corner. This is the easiest way I could think about.

I tried it with 300 values and it didn't break.

Though this version wouldn't allow to go backwards though, which means "when it is checked, it is ! "

Requires 5.5 or higher

FileMaker Version: 6

Platform: Mac OS 9

DynCheckboxes.fp5.zip