Newbies dkalha Posted April 24, 2006 Newbies Posted April 24, 2006 I have a database which holds the name of organisations (field: ORG) together with the type of organisation (field: TYPE). The TYPE filed is populated using a checkbox field created from a predefined VALUE LIST. I want export lists from the database of organisations that match each of the VALUE LIST values. I can do this manually by finding all ORGS that match first value, sorting, exporting, etc. However, there are over 30 values in the VALUE LIST which proves incredibly labourious. Also the VALUE LIST grows as new types of orgs are added. Is there any way to automate this in scriptmaker? Any pointers would be useful. Many thanks
Kent Searight Posted April 25, 2006 Posted April 25, 2006 This does basically what you want but you still have to manually name the files on export. If you move up to FM 8 Advanced you'll be able to take advantage of Script variables. These will allow you to lose the global field TempText and to dynamically name the export files, thus totally automating your process. ValueListExample.zip
Kent Searight Posted April 25, 2006 Posted April 25, 2006 Just on the off chance you have FM 8 Advanced, here's an example that uses variables to replace the global field and to dynamically name the export file. Hope these help! ValueListExample2.zip
Newbies dkalha Posted April 25, 2006 Author Newbies Posted April 25, 2006 Kent_S Thank for your prompt response. I have downloaded the files you posted and will attempt to apply the principles to my database. I will feedback when I get some results. Thank you again
Recommended Posts
This topic is 6789 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