There are numerous ways to do that. Can you describe what you want in more detail to help us better select a method suited to your needs?
I'm looping through one table and doing finds on another table. I only need a couple fileds of information from the seecond table, so I set a varible to the field I need and set the field of the firest table to the variable.
What you describe should work. How is it failing for you?
You may need to post the script that you are using.
To post a script to the forum:
- You can upload a screen shot of your script by using the Upload an Image controls located just below Post A Answer.
- You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF to your clipboard for pasting here. (with this approach, you can get multiple script steps on the same line, please edit the pasted text by inserting some returns to separate those steps.)
- If You have FileMaker Advanced, you can generate a database design report and copy the script as text from there.
- If you paste a text form of the script, you can use the Script Pretty box in the Known Bugs List database to paste a version that is single spaced and indented for a more professional and easier to read format.
Thanks for the help. Turns out I chaged the layout before I assigned the variable.