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?
