Obtaining data from a database to use as a selection criteria
Forums
Dear All,
Currently i am making a script that is supposed to extract all cash transactions in excess of 15K. The data that i use is an auditfile(.adf). This is a database with all the journal entries of a financial administration.
In this script i let the user select in a dropdown menu which field contains the general ledger accounts. In the next dropdown i would like to let the user select an GL account(like cash or housing expense). And in the last dropdown the user selects which field contains the actual amount. The script will than create a new database which contains all transactions in exces of 15K for the selected GL account
My problem is that i do not know how to extract the data in the field "GL Account" and populate the second dropdown menu. Would anyone know how to do this?
Many thanks in advance
Hi Herbert,
Hi Herbert,
I have put together this script to show you how to do it. It is not something that is easily done within IDEA as you first have to select the field, then when the field is selected summarize it and then populate an array with the summary information and attach that to the dialog. Definitely some advance scripting. So here is an example, I have also attached it for you to download and play with.
Good luck.