An invoice date range
A shipping date range
A shipped to state
A product code (relating to invoice line items)
I want the end user to be able to select a specific customer record to edit from a list of customers where the list of customers is based on the criteria entered.
I wondered if the solution might be an SQL view, but I have never created an SQL view so now more questions come to mind. Can the view be parameterized so that the only records in the view are records that match the criteria the end user entered? What happens if one of the criteria is left blank by the end user? So many questions and so little experience, but I am beginning to get the picture.