Question

concat a lookup field returns id fron a third linked table instead

hi all, i am sure this should be easy and i cannot get it to work

i have a products table {product id} and {product name}

a menu table which pulls the product name using the product id

and an orders table which lookups the product name from the menu

i am then trying to concatenate in orders the product_name and qty into one string

{products}&" ("&qty&")"

{products} here is a lookup field

i’m expecting Bread(1)

but instead get 2(1)

2 is the product id

i’ve tried formula, arrays and rollup function

thank you

+32

Could you provide screenshots of your tables? I tried to recreate it but aren’t quite sure how the ‘Menu’ table works

---

Off the top of my head, you could try:

Adding a lookup field in Menu to grab the product name, and then in Orders add a lookup field to display that lookup
In the Products table, change the primary field to be the product name instead of the product ID
In the Menu table, set it to display the Product Name field instead of the Product ID field