Is it possible for me to have a table on a page, and then to select a row in that table by click or mouse over and then have another table or collections list change to show data where there is a relation to what has been selected?
Not sure what you mean.
Do you want to be able to change page based on the line you click in a table to access a different table and filter the data in that table based on information from the line you selected on the first page?
If that’s the case, you could do it with a workflow on the line of your first table and a filter on the data in your second table that changes depending on the value of a variable.
We’ll actually be showing something similar in today’s office hours on YouTube at 12pm EST and making the recording available afterwards
Or is it something else entirely you’re trying to do?!