Finding a variable value in a script

[Ben vd Beek]

With FM7, the next question.

If I have 2 tables:

BOOKS with field AuthCode and global field gAuthCode

AUTHORS with field AuthCode

joined one-to-many on AuthCode from AUTHORS to BOOKS.

I have a form with gAuthCode on it. This shows a dropdown menu of the AuthCodes from AUTHORS.

User choses one of the authors form this list.

I now want to make a script finding all the BOOKS from that author. I can do script step PERFORM FIND, but there I cannot give a fieldname gAuthCode as a value, because only plain text is allowed. How can I make a script step to filter only the BOOKS from the author in gAuthCode, after which I eg can print a list of thes books?

[mz123]

Hey there -

You could do:

Enter Find Mode

Set field [ author; gAuthCode ]

Perform Find

that should do it :