Jump to content

Related Fields in Find mode


This topic is 7207 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

This topic is 7207 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.