>I tried it already... and it works.. tanx...
>
>> On another note, unless you're working on an application that already uses formsets, I'd advise you to stay away from them. They complicate things without adding any value.
>
>Does it mean accessing shared tables in a formset will lead to complication in my program later on? I'm currently using formset, and i applied the USE... SHARED command, while i use SELECT if im just searching for a record.
>

The problems with formsets aren't so much about data access. It's just that the product isn't really designed around them, and some newer capabilities don't work with formsets (if I remember right). Also, very few people have used them, so there aren't many articles about them, and not a lot of people who can offer help if you have problems.

Formsets were included in VFP 3 to provide an upgrade pathj for people who'd been using screensets in FoxPro 2.x. Neither Microsoft nor most VFP experts have ever recommended them for new development.

Tamar