Possible to filter on one dataset based on the results of another dataset in a page?
I have a user table and an activities table. I want to track the activities over time, but since there are too many activities, if I include a user details for every activity, the dataset will be too large. I want to be able to filter the activities by features of the user. And the features are contained in the user table.
User table has each row corresponding to a user and a lot of columns including ID (user id).
Activities table has only two columns, (1) ID, this is user id and the primary key of the first table. (2) Activity
By filtering on a column in the first table, country for example, is it possible to then have it tie up the IDs corresponding to the country that I have filtered on to the activities in the other table? So that when I select a particular country, only the activities of that country are shown?
Thanks in advance!