I just need to know if it can be done with join tables
Is it possible for dataAssit to create a search page to search either by customer ID or customer NAME? I have joint customer table to quote table.
customerID (primary key)
quoteID (primary key)
customerID (foreign key)
SELECT quotes.quoteID, quotes.customerID, customers.customerName
LEFT OUTER JOIN customers ON (quotes.customerID = customers.customerID)
Can you please point me in the right direction where I can make the adjustment.