Hi David
Thanks to everyone for their spot-on suggestions about magical merge
fields! I have another question that vexes me.
I’m designing a database for work. We need to be able to enter any
number of objectives into the database and mark them as active or
not on an individual basis. This part is easy. What I’m having
trouble wrapping my head around is that later on I need to give
people the option to select from a drop-down list of only those
objectives that are marked as active. I initially had created a
value list from the objectives table, but that won’t exclude
objectives where flag_active is 0 (inactive). I suppose I could
build another table of objectives that only includes those from the
original that are marked as active, but wouldn’t it need to be
rebuilt from scratch every time an objective was added or its status
was changed? I don’t want to delete objectives, just mark them as
inactive, because they might be needed again in future.
The simplest approach is to make a calc field like
Case (flag_active = 1 ; obiective_name )
and base the value list on the calc field
Ciao
G. Pupita
Certified FileMaker 9 Developer
FileMaker Business Alliance
