This one is way over my beginner head. Here are my tables:

- tblCredit
CreditID
CreditNumber

- tblCreditItem
CreditID
ProductID

- tblProduct
ProductID


I need data from tblcredititem and tblproduct. I have a creditnumber.