Vaughan Posted January 30, 2002 Share Posted January 30, 2002 Help. I'm trying to perform a find based on a value that's in a text field in a related database (a preferences db to be exact). My code is: code: Enter Find Mode [] Enter Calculated Result [select, ""==""] New Record/Request Enter Calculated Result [select, ""==" ] Perform Find [] I keep getting two requests with "==" the related field doesn't get entered. Yes there is a value in it! I've also tried set Field [] without success either. Can related field values be seen in find mode or do I have to bring it into a global field in Browse mode first? Link to comment Share on other sites More sharing options...
slstrother Posted January 31, 2002 Share Posted January 31, 2002 Hi Vaughan, You are able to use the value from a field in a related file for your find criteria. From your post, it looks like you are trying to find an exact match. I had a little trouble getting the script to work with the calculation "=="& relatedfieldvalue. So I created a calculation field in the related file called "exact value" with the result "==relatedfieldvalue" and used that field in the script. I also took out a couple of script steps. code: enter find mode[] insert calculated result[select,"relatedfile::exact value"] perform find[] This worked on the test I did. I hope this is what you are looking for. Good Luck, Steve Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8122 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