>Having a list of available items to pick from and then having that set displayed in the same fashion as the fields tab in the query designer is what I am hoping to achieve. Is there an easy way to do this or do I need to start from scratch? I'm guessing I would need to use grids to best accomplish this? Am I pointed in the right direction?
>
>TIA
1. To get list of available fields, you can look at AFIELDS().
2. To pick up selected fields only, you can use macros in SELECT-SQL command.
3. To show SELECT results, you can use grid.
Edward Pikman
Independent Consultant