When I have a table Activity with a connecting table to Item. This is the table Activity_item. Since I can connect several items to several activities.
The connection table has 2 columns, activity_id and item_id, both the pk.
The end user however would like to see more data from the item_table weight, owner, position, etc.
Currently we can one get this data by creating a view from the connection table, join the tables and show all data needed. This is quite unpractical.
What other ways would be possible to solve this, since connecting tables will (almost) always need more data from the other tables. I do not want to save duplicate data of course..