I have two tables, “User Database” & “Job 001 Applications”, both have varying data points, but an applicants unique ID will appear on both tabs, to link user data to a users application and that specific data.
In theory, user data remains the same, however their application data may very for each application, ie Job 001 & Job 002.
I need to display both tables data in a dash board, in 3 views, user data, user detailed view, and the application specific data.
When I activate the “Interactive Mode” for the dash board, obviously the User Data and detailed user data, are correlated and so both change in unison, but the application data does not change, to newly selected user, thus not showing the correct application data for the user that is selected (it has to be done manually). Any solutions around this?
Any other ideas, are always welcome. Application
Application data kept separate from user database, but is linked to a user.