How to join three tables using SQL
joining loan and customer tables using customer_No
joining loan and payment tables using
Text1.text = Payment_No
Text3.text = Customer_No
Private sub find_click()
dtpayment.recordsource = "select * from payment where Payment_No = '" & text1.text & "'"
dtloan.recordsource = "select* from loan where Loan_No= '" & text2.text & "'"
dtcustomer.recordsource = "select * from customer where customer_No = '" & text3.text & "'"
How this doesn't work