1616 Posted May 15, 2006 Share Posted May 15, 2006 Not sure if this is possible and i dont have a clue how to do it. I have a checkbox set (Setup;Participants)with a list of numbers from a value list determined by the field(Members;Member No). I need a script that will go to the Layout Members and go to the relevant record based on the numbers being the same, of every member checked. Eg I check the numbers 1 4 and 6, the script will go to the layout members and go to the records with the member Numbers 1 4 and 6. All help is greatly appreciated. Link to comment Share on other sites More sharing options...
John Mark Osborne Posted May 15, 2006 Share Posted May 15, 2006 The neat thing about a checkbox is that it stores the checked values in a return-separated list. In a relationship, a return-separated list is called a multi-key. Each value in the list can match a value in a related table. So, all you have to is create a relationship from the check box field in the Participants table to the corresponding members field in the Members table. Once you have the relationship established, use a script with the Go to Related Record script step with the "show only related records" option checked to place the related members in a found set. Link to comment Share on other sites More sharing options...
1616 Posted May 15, 2006 Author Share Posted May 15, 2006 Its still not working it shows every record in the member layout Link to comment Share on other sites More sharing options...
John Mark Osborne Posted May 15, 2006 Share Posted May 15, 2006 Did you make sure to check the option to "show only related records"? If so, post your file here so I can take a look at it. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6555 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