Hi,

I'm changing an app from BDE to IB6. I need to calculate an
accounts-recibable aging report, on 1-30, 31-60, etc. days... The trick
comes with the exchange rates, which each user can enter to make their
estimates.
Each account invoice can be in franks, dollars, pesos, etc. So the user
enters a list of estimated exchage rates, this can be different for each
user, sales gets some numbers, accounting others, and CEO others.
I used to have 2 databases one locally so each user entered his/her own data
and then make a few queries joining both databases for each user to make
their own calculations.
Something like:

SELECT Ammount, Currency, ExRate FROM S:\SERVER\BIG.DB A INNER JOIN
C:\LOCAL\SMALL.DB B ON A.Currency=B.Currency;

How can I do this with IBO / IB?

Thanx in advance.