Get material naam

[Erwin_Demeulder]

I have two table “reservation” and “Material”, both have a field Material number and material name
when i need een material i put in reservation de material number and i need automatic fill in de material naam.
Lookup, don’t work (get list and not tekst)

[Lynn]

Hi @Erwin_Demeulder What is the expression you are using that is giving you the list?

[Erwin_Demeulder]

This is de formula in field artikelnaam in table reservation
LOOKUP([Artikelnaam], “Artikelen”, “Artikelnr”, “Artikelnaam”)

Translate:
Artikelnaam = material name
Artikelnr = material number
Artikelen = is table material

[Erwin_Demeulder]

It’s in dutch
sorry for my English

[Lynn · Accepted solution]

Hi @Erwin_Demeulder You could try
ANY(SELECT(reservation[Name],[Material Number]=[_THISROW].[Material Number]))

Or does your Material Number Ref the reservation table?

[Aleksi]

Or like… LOOKUP([_THISROW].[Artikelnaam],Artikelen,Artikelnr,Artikelnaam)

[Erwin_Demeulder]

Artikelnr is ref.
Artikelnr is know by user artikelnaam will than automatic fill in?

[Lynn]

Hi @Erwin_Demeulder

help.appsheet.com

Dereference Expressions

Use a dereference expression to retrieve a field value from a referenced record.

[Erwin_Demeulder]

Thanks its works