Newbies The Pidg Posted May 8, 2006 Newbies Share Posted May 8, 2006 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? Link to comment Share on other sites More sharing options...
IdealData Posted May 8, 2006 Share Posted May 8, 2006 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. Link to comment Share on other sites More sharing options...
John Mark Osborne Posted May 8, 2006 Share Posted May 8, 2006 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 Link to comment Share on other sites More sharing options...
Newbies The Pidg Posted May 10, 2006 Author Newbies Share Posted May 10, 2006 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6558 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now