Hi!

You can load all companies info into local cursor and index it. Then locating company by ID in such sursor is a single function (Lookup()) that is optimizable (and thus instantaneous with local cursor even with large number of records) and could be used as a source, for example, of grid column to display it. Only problem is downloading list af companies into separate cursor and index it at start of app or form. It could be a view as well, but just separate. You can index alias on the fly (include temp cursors and views) using INDEX command. Index file for index over the temporary resource (like cursor or view) is deleted automatically when alias closed.

HTH.

>I am rewriting a custom program that interfaces with some Accpac Pro Series data. In the original program, the tables were accessed directly. In this new version, I'm trying to get away from that so it won't be major trama if they ever want to change accounting systems. I figured I'd write some sort of bridge program that would go fetch the data from Pro and then that would be the only thing I would have to change if the accounting system changed.
>
>In theory, that should work fine for the parts where I'm basically just summarizing Pro data. Where it falls down for me is when I need to mix the Pro data and the custom data. What I've run into specifically is the customer name. The custom program stores the customer ID, which is from ARCUST. But I would rather not store the company name in the custom program.
>
>I have a view that shows all the jobs and currently shows just the customer ID. I'd like it to also include the company name. Since I don't want to access the Pro table directly, I can't just include it in the view. I thought about including a custom function in the view that fetches the company name record by record, but it seems like that would be insanely slow.
>
>Has anyone run into this before? Is there a good and fast way to handle it?
>
>Thanks,
>
>Michelle