I don't need add any new fields or tables for my solution, and I don't think there's an issue with multiple users?
The table the report runs against contains [shipment date] and [outbase]
User runs the report; to do that they have to provide values for the [shipment date] and [outbase] as ask the user filters.
The report runs showing the relevant records, including my formula URL button.
When they click the button, it opens the form for the record they clicked on in the report.
When they click save & close, they're taken back to the report with the same criteria because the nexturl part is picking up the shipment date and outbase from the record they clicked on in the report in the first place.
If a different user is running the report with different ask-the-user-filters, the record they click on will have different values for those two fields, which get picked up in the nexturl - which takes them back to the same report, but with their selection filters applied.
------------------------------
Jonathan Spencer
------------------------------
