***ANDY*** Posted March 1, 2005 Share Posted March 1, 2005 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 Link to comment Share on other sites More sharing options...
comment Posted March 1, 2005 Share Posted March 1, 2005 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. Link to comment Share on other sites More sharing options...
***ANDY*** Posted March 1, 2005 Author Share Posted March 1, 2005 That's It!! Thank you very much, Andy Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6605 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now