>let me tell u the story.
>
>I have a table with some records and have relation with another table. I used command set index to (eof('b'),a.x,b.y) into idxfile.
>set index to idxfile.
>
>Now if I add some record into this table from a form then this index does not work but if I close the form and come again then it does work.
>
>Thanks for your reply.
As I've said, I don't understand your indexing, but that's not important here, as you seem to say that it works. All I'm saying is that you need to move the file pointer to see it work. If you close the form then come back in then you are "refreshing" the data implicitly. Here you need to do:
set index to (eof('b'),a.x,b.y) into idxfile.
set index to idxfile.
Locate && (or Go TOP)
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.