-
I am having problems with getting an MSFlexigrid to show data from multiple tables at once.
i am sure that the sql is to blame
i need to reference firstname and lastname from a different table if the customer number matches with the account number
SELECT ACNumber, OpenBalance, TransType, TransAmt, ClosingBalance, Date, FirstName, LastName From LoanAcHistory, Customer WHERE ((LoanAcHistory.CustomerNumber = LoanAccount.CustomerNumber) AND ('" & iAccSearch & "' = LoanAccount.ACNumber))
ORDER BY Customer.LastName"
-
You are missing the LoanAccount Table from your FROM clause. Also remove the " from your ORDER BY. Try that, let me know if you are still having problems.