Ouch sorry I didnt mention its FPD25b Im working in.
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