Hi,

I have a list layout with one field "Food And Drinks" that you can add (new record) the kind of food or drinks (wines, meat, soft drinks, veg, beers....). i did that because i want that, each time you add a kind of food or drink at the "Item" field of the invoice and you click the "ADD" button, i want that a script check if you have choose the type of service (Room service, Restaurant, Bar) for this Food or Drinks. BUT only when the "Item" at the invoice is one of the "Food And Drinks" record of the list layout.

My problem is that i can't find how the script can check if the field "Item" content one of the "Food And Drinks".

Sorry for the English!!!

Not IsEmpty ( FilterValues ( Item ; Food And Drinks ) )

returns 1 ( true ) if Item is a value of the list, else returns 0 ( false )

BTW: you can turn on the validation of Item as member of a value list coming from the field Food And Drinks