Random things

[The Pidg]

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?

[IdealData]

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.

[John Mark Osborne]

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

[The Pidg]

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.