[QUOTE=neil.batchelor254136;46721]I have tables of data that I ask users to fill in.
1. User Data
2. Venue Data
3. Resturant Data
4. Meeting Rooms Data and more
When the user creates an account they get a USER ID PRIMARY KEY.
The Session ID = USER ID of the logged in user is populated in each of the tables 2 3 and 4.
This helps me keep track of who has updated and added data into tables 2 3 and 4.
So each table 2 3 4 have a USER_ID column or similar that is populated with the USER_ID from the User Data table = Session ID.
However I would like to create results table that tells me which users have which records.
Example of ideal results table attached in zip
If any of the columns display 'Yes' then a count of the number of records for that user in that table, then I would like to be able to click through and see another results table showing that number of records for that table for that user.
I appreciate this is complex and I have very little idea how to do this, but it is crucial to my business that I build this as soon as I can with Data Assist.
Many thanks,
Neil