I am working on fixing the touchscreen issue in RMS and have gotten it to work, but my only concern is that after running the UPDATE queries, I will have duplicate TenderID values in the historical TENDERTOTALS table. (The TENDERTOTALS for the open batches are okay)
My question is - it appears that the TENDERTOTALS table is simply a staging table, meant to keep track of the tender totals prior to the closing of a batch by running a Z report. If that's the case, then I shouldn't foresee any problems down the road. But if the TENDERTOTALS table plays other roles in the db, I'd like to know what these are so I can look ahead at any potential side effects of those update queries.
I appreciate any feedback I can get on this - thanks.