Show data from connecting tables without a view

  • 17 November 2023
  • 4 replies

Userlevel 5
Badge +12


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.. 






Best answer by Mark Jongeling 21 November 2023, 23:13

View original

This topic has been closed for comments

4 replies

Userlevel 2

Hi Blommetje,

A other option I could think of is adding a expression field to your connection table. 

Userlevel 6
Badge +16

Can you clarify why you want to avoid a view? Because it sounds like that's exactly what you are looking for?

Userlevel 7
Badge +23

Adding to Erwin's reply, you can look into Meta auto or Meta custom views:

Those views do not require manual coding but are automatically generated based on your given tables and columns. Very handy for the more simple views. 

Userlevel 5
Badge +8

Hi @Blommetje,

Were these reactions sufficient to solve your situation?