Forum Discussion
Customers from a same company different campus
I am trying to build a database to quote my products and i have a challenge managing customer information. Let's say i have a customer working for a university, and this university has several ca...
Maybe this would work: offer the user several text fields to enter search terms. Then concatenate the address fields, and do a Contains search in that string for each of the search terms. Show all results in a list for the user to review and double-click to open a form to that record.
Another idea would work if there is a lot of repeat business. For example, the Earthquake lab may break a lot of glassware (ha, ha) and will order more on a regular basis. Then the search terms could look back in previous orders.
Another idea would work if there is a lot of repeat business. For example, the Earthquake lab may break a lot of glassware (ha, ha) and will order more on a regular basis. Then the search terms could look back in previous orders.
Ha, ha, ha, they probably will.
Nice approach, on the search tip.
