Hi everybody,
I removed integer ID from the Orders table, so now it is back down to only two fields OrderPK and the Date.
The question now becomes is how should I program the Search interface. Suppose, I want to search orders by Date (there is nothing to search them for otherwise anyway), then what should I display in the grid for users to pick? I can probably add either number of items or just show all the items, but in the second case, how do I visually separate orders?
And in the first case (adding number of items per order) does it mean again adding an extra 'virtual' column to my TA?
Thanks in advance for your ideas.
If it's not broken, fix it until it is.
My Blog