Hi Everyone!

How can I search (preferably a SEEK()) through a local view, without having to index it at run-time?

I use a local view to update a base invoice file. I do this because I use the primary incremantel index key as the actual generated invoice number. I only require this invoice number (primary key) to get incremented if and only if the user decides to save the invoice (TABLEUPDATE()).

It works great, but when trying to find an invoice, to perform and edit, view, void, etc., I would like search through the local view using a seek, since I am using a local view all the time.

This is a multi-user application, so I do not want to creat index files evry time a user enters the invoice file, just to perform a seek.

Is there a solution to this? If not, can I use another search method on a local view, which is fairly fast and efficient?

Thanks in advance!