>Ouch sorry I didnt mention its FPD25b Im working in.
>
That's important, you should mention it in the beginning. Indexseek was introduced in VFP6, so you can not use it. I don't remember details about keymatch. Check it in the Help. Insert from memvar could fail, if you don't initialized each field variable. However, in most cases it's preferable, than append blank + replace. Too bad, that there is no syntax INSERT FROM OBJECT (NAME). In VFP you can use scatter name /gather name commands...



>Anyway the second option looks much better to me at the first glance. I am initializing variable any way so if not seek() then gather memvar. Thats great but this is going to happen only once when the table is empty all other time the gather will never be needed as the records will already be there be the time we run the app twice or more. This is just to safe guard the app from the user deleting records or changing the narrcode etc. You know how users are with data <g>.
>
>Thanks for replying
>
>Regards
>Bhavbhuti