March 1, 200520 yr Hello Together, say I want to search for a Last Name in my database, so far no problem using the find layout. But now I want to do the same thing, only that I enter the name I want to find in a separate field XY which is on a different layout called SEARCH. The entire thing looks like: Enter name you are looking for into field XY >> then click button FIND. After the name is entered into the field I want to push the FIND button that has the find script assigned to it. How would my script have to look like? So far I have the following: Enter Browse Mode Go to Layout ["Data"] (this is the layout all names are on) Show All Records Enter Find Mode Insert Text [selcet, "Last Name",""] Perform Find[] How does my row Insert Text [select, "Last Name","=???"] has to look like? If I click the Specify button I'd have to enter a certain name but I actually want the script to function that it looks for the name that is entered into the XY field. If this sounds too confusuing I can upload the fp5 file. Thanks guys, Andy
March 1, 200520 yr Try: Enter Find Mode Set Field [Last Name, XY] Perform Find[] This will work for everything except date ranges. Make sure XY is a global field.
Create an account or sign in to comment