User interface problem with Pop-up menus and exact finds.

  • Follow


I'm using FileMaker 7 and Server 7 and I've run into user interface
issue.

I want my users to be able to do EXACT finds on fields defined with
pop-up menus.  A popup menu gives them no chance to enter keywords to
modify the find.  I have field values of "D Done" and "  Not
Done" and a search for "D Done" matches "  Not Done" as well.

I can't change the field values and I don't want to lose my popup
menus.  Is switching to a popup list my only hope?  I'd like some way
to control the kind of find myself rather then ask the user to use the
symbols.

Russ

0
Reply kosherpiggy (7) 5/5/2006 6:21:24 PM

I don't know if it could work as your description is not 100% clear to me. 
But I'd think you may take advantage of 2 factors. One, that you may create 
a new field which by calculation could be made to match exactly the pop-up 
menus contents. And two, that you may search on one field and show two 
fields.
As a (dummy) example of the first factor :
NewField (calc) = Case (Substitute(PopUpField, " ", "_") = 
Substitute(FieldToBeFound, " ", "_"), "X", "")
And for the 2nd factor :
A CustomerID field set to popup that shows both the CustomerID and the 
CustomerName.
It may take time for you to adjust that to make it work the way you want.
Remi-Noel

"Russ" <kosherpiggy@hotmail.com> a �crit dans le message de news: 
1146853284.676864.113940@j73g2000cwa.googlegroups.com...
> I'm using FileMaker 7 and Server 7 and I've run into user interface
> issue.
>
> I want my users to be able to do EXACT finds on fields defined with
> pop-up menus.  A popup menu gives them no chance to enter keywords to
> modify the find.  I have field values of "D Done" and "  Not
> Done" and a search for "D Done" matches "  Not Done" as well.
>
> I can't change the field values and I don't want to lose my popup
> menus.  Is switching to a popup list my only hope?  I'd like some way
> to control the kind of find myself rather then ask the user to use the
> symbols.
>
> Russ
> 


0
Reply Remi 5/5/2006 9:02:32 PM


Hi Russ

I just did this in my own database

Make a find layout with global fields mirroring the fields you want the
user to search.
Then write a script

Set error capture on
Go to Your Find Layout
Enter Find Mode
Set Field [your real field;your global field]   <-----do this for each
field you want the user to be able to search
Perform Find
if get(lasterror) > 0
Show custom Dialog ["There are currently no records that match the
criteria you specified"]
Show All Records
End If
Enter Browse Mode
Go to Your Browse Layout
Set error capture off

0
Reply averbach (17) 5/5/2006 11:30:11 PM

2 Replies
177 Views

(page loaded in 0.064 seconds)

Similiar Articles:













7/30/2012 8:53:35 PM


Reply: