General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using views with mixed data
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only