Lookup Shown Column only show id

[witwall]

for example, I have two tables,

• hello_brand:brand_id, name
• hello_product:product_id, brand_id, name

When I set hello_product.brand_id as lookup row, and tried select Lookup Shown Column, only brand_id is available.

but example project works(if I create new lookup table, does not work either)

[witwall]

I found the issue, the role of hello_brand.name is NULL, and if I update it to empty(''), the name column will show.

[goFrendiAsgard]

Thank you. I'll try to inspect this futher