I have a "master" table containing Clients, and an interface page that presents selected information as a dashboard launching point for each client.
I have a separate table where clients can input "evidence" of all kinds, and from that I can filter, sort, whatever until I can work with that information however I like. I have an interface page for this table as well, where I can manually select which client I want to review the evidence for - and that's where I need help.
I want to have a button on the Clients interface page that will take me to the Evidence interface page with data already filtered to match the Client from which the Evidence button was clicked. I don't know how to grab that information (client name) from the Clients interface and feed it to the Evidence interface filter element before I even land there, as a clearable filter (b/c I might then want to stay in Evidence but move around to a different client without backtracking to the Client interface).
Thanks for any help!
