Create a results table which brings in cross reference data from other tables
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.
Venue Data Rest. Data Meeting Rooms
User 1 Yes id 1 No Yes, 7 records in total, id 1
User 2 No Yes 2 records in total, id 2 Yes 1 records in total, id 2
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.