In the enclosed DB, qryQuoteCalculations, I want to link the tblCustRFQ with CustDisctbl on 2 fields EndCustomerCode and Group with EndCustCode and Category. The value of TotalDiscount in CustDisctbl is needed based on a combination of the endCustCode and Category
The qry gives an error if I join the 2 tables on 2 fields.
How is this done? I think it can be done without editing the SQL code. I was shown this once but cannot recall how it is done
The qry gives an error if I join the 2 tables on 2 fields.
How is this done? I think it can be done without editing the SQL code. I was shown this once but cannot recall how it is done