Hi!
You can use PACK only for table opened in the Exclusive mode. Using a PACK in the user interface is quite bad idea. Just use the SET DELETED ON setting and it is enough.
There are no easy way for that. Forst of all, make a simple combobox for that. Than improve to add new values. You have to program everything by self, there are no built-in tools for that in VFP.
Well, I can try to make it and post it into the files section here, if I have a time. However, its hard to make it generic enough to cover all use-cases.
HTH.
>I have a small form, only two fields. Data environment has only one table, which opens as exclusive. If I try to delete-pack the record on screen, I got a "File is open in another work area" message when the code reaches the "Pack" command. How to avoid this?
>Also, anyone knows of an easy way to place a combo/list box in a grid that shows single (no duplicate) values from a table, writes one of those values in a new record, and allows the user to add new values?
>TIA
>Ulises.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.