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?

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