Multi - User work areas
I've created a summary report that uses a work table that I clear (DELETE ALL), selects data from mutliple tables based on the users requests and then creates records in the work table for reporting.
But if multiple users want to run the report at the same time but for different criteria, they will be conflicts in the work table.
Besides globals, what can I use for individual users so that they don't run into each other ? I'm guessing that I'll have to create globals with 32000 occurences each to use as my work table, but am hoping for an easier solution as navigating (sorting, scrolling,...) would require me to write some rather unusual code that I would also have to alter for each new work table.