I want to create a detailed user log.
currently, I have created a table that stores the Id, date, userId, table name and table id.
if I run a query it works fine to display basic details. however, if I want to display the contents of the table name and Id I inserted I run into a crappy situation where I would need to create a procedure. the procedure would run the basic select and dynamically join the other table based on the table name and table id I inserted into the log database.
another problem is that not at tables are the same therefore this method would only partially work anyways.
the table names field is manually added when adding the log data set
how can I accomplish a nice log?