In the "Using "*" in filtered relations" thread I mentioned that I have
a filter field, a global, that filters name from a related DB.
These names can then be used to manipulate the related_ID field, with a
value list built from the names filtered on the global value. The actual
related_ID field have been set to white text on a white background, so
that the name coudl display on top of it in the global instead or
perhaps the actual name field.
I made a test popup with a related record value list with names and
their ID values, that when chosen puts the ID into the field that has
the popup list. This is set to white text to hide the ID value as long
as the user remains there. On top of that, I've put another field with
the name value above, in order to display the selected name.
I can do that with the real field for name "Name" on top and still reach
the popup list, if I uncheck "Name" to "allow entry into field"***. This
way I can circumvent how Filemakers value list display, and get rid of
the ID value on the layout, which is nice, except for on the actual
popup list itself.
But I wonder if there is some way to maintain edit ability of the field
on top and still reach the popup list in the field below. Because it
would be very cool if the filter global could sit on top, let the user
enter a string and make the choose from a filtered list. I'd have to
maintain the value in it of course. Any ideas for making this possible
or suggestions for another strategy are equally welcome.
***I asked earlier about 2 months a similar question in "Not displaying
the ID value in popuplists in Portals" and Bridget Eley was ver kind to
suggest the method I refered to above.
||11/28/2003 10:22:34 PM