Hello,
I have two tables related in a many-to-many relation as shown here:
what I'd like to get is to create a catalog reference module, to be shown for example in "component details", which relates the selected component with the works related.
I tried by adding a standard catalog reference module, using "components per work" as catalog and "components" as selected referenced catalog. What I get is the list of records in "components per work" related to component, which is good.
Obviously - having the list of works related to the component I'm looking at - I'd like to have a link to the related work details. Hence, I put a link on the "work" field and override the redirect page to work-details. This does not work, because the link is opened with the ID of the "components per work" record, whilst I'd like it to be opened with the "work" cell value, which is the ID.
An example:
Work's ID: 33
Component's ID: 3
Record in "components per work":
- row ID: 1
- work: 33
- component: 3
- quantity: X
in the module I see a row with the data above and a link on the "work" field. That link does not take me to the "work details" page with ID = 33, it takes me there with ID = 1, since 1 is the row ID in the "components per work" table.
Do you know if there's any way to perform such a task?
Thank you
Bookmarks