I'm trying to set a table to pick up at random a value from a particular field in another table. The tables are related by these two fields. Can anyone help?

The only things that's random in FMP is the Random function - check out the help.

Maybe you can use the result of the random function to build up the record id that makes the match into the related file.

It's unclear what you want based on your short description. However, I have put together a file I think might help you. The two tables in the example file are Companies and Employees. From Companies, you can click a button that randomly selects one of the Employee IDs, places it into to a field and uses it with a GTRR script step to go to that employee record. If you provide a better description of what you want, we might be able to help better.

randomthing.fp7.zip

John, you've done a great job at interpreting my problem. Thank you for your response and example. It exactly fixes my problem. I couldn't work out how to randomly select an item from a set value list.