I have a big problem with a grid that i cant quite solve. In an application, I want to use a grid control that will show the user a list of choices. These choices come from a table. If I run the application from within VFP, everything works fine, but when I create an EXE file and run it, the grid shows even the records with the "deleted" mark, and of course I dont want that to happen.

So i tried to open the table exclusively so that I could pack the database each time the user chose a record, but when the application loads, it tells me that the file is in use.

I also tried to set the grid's record source property to alias, and then open the table shared, but I can't get the grid to show anything ( I also tried many other things such as setting the column's control source property to the fields of the table, but nothing worked)

Does anyone know how I could get the EXE file not to show the deleted records (or maybe another way i could get the grid to show the right things)