Get joined data on detail view

[dolly2]

Hello,
I don't know how to get data from a joined table in (custom) detail view:

for example, my first table is
Categories [id, name, description, ...]

and my second is
Articles[id, cat_id, ...]
with article.cat_id link to categories.id, of course...

On the form view I have a dropdown list with categoires.name as label and categories.id as value, that's ok.

Now on detail view I'd like to show category's description.


How can I do this ?
If I set up a join in list > Data > joins, I have all the categories form in article form. That's not what I want.

Thank you for your help...

Thak you

 

[PaulV888]

Hi,

Did you look at the description field of a drop down element? Go to your cat_id element and the Advanced tab. There you can add the category's description to the description field. This would give you both in the edit view and the detail view.

I you don't like that, you can copy the whole list, change your cat_id dropdown on the copied list to show description. Then on your main list point to the copy in the "Custom detail URL"

 

[Jaanus]

I think we talk about databasejoin element. Yes, there you can use description.

 

[dolly2]

Yes
That was so easy!
Thank you...

[Love Fabrik ]