>I have a form with a simple grid used as a pick list. There is only one column in the grid that contains:
>"trim(cust.fname)+' '+ cust.lname"
>in the column source. It works fine until I run a second form. The second form also has the cust table in it's data environment but it is related to some others as well. When I come back to the first form and view the grid it contains no data most of the time. The forms are modal and I am not using private data sessions. I ran a "list status to john1.txt and john2.txt before and after running the 2nd form and they show the same tables open in the same places.
>
>Any ideas?
>
>Many thanks in advance. You guys have been really great.
I think Mark pegged your problem. To add, if you want to stick with the default datasession, don't add the tables to all of the forms, just open them once in a startup routine, or only place them in the Top-level form's DE.
But the best solution IMHO, is to use private datasessions. It helps keep things more OO too, forcing you to pass parameters as opposed to depending on the state of calling forms.
Erik Moore
Clientelligence