In my QVW, I have several fields for date. They are dates for different things: Assembly Date, Order Date, Delivery Date, etc.
I want to create a list box where the user can select a year or several years, and then populate a table with everything that happened in that time period. So if the user selected the year 1996, they could see everything that had been assembled, ordered, and delivered in 1996.
I do not want to just give all the date fields the same name, as I am worried that will create circular reference problems. Does anyone know of other solutions?