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)
Solved! Go to 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?
Hi @Erwin_Demeulder What is the expression you are using that is giving you the list?
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
It’s in dutch
sorry for my English
Hi @Erwin_Demeulder You could try
ANY(SELECT(reservation[Name],[Material Number]=[_THISROW].[Material Number]))
Or does your Material Number Ref the reservation table?
Or like… LOOKUP([_THISROW].[Artikelnaam],Artikelen,Artikelnr,Artikelnaam)
Artikelnr is ref.
Artikelnr is know by user artikelnaam will than automatic fill in?
Thanks its works
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |