Hello,

I am trying to define a view for a sub-group of elements of the database by defining some criteria for this view. When the criteria is on a field with a standard type (text, list of elements,...) it works, but when the criteria is defined on a "lookup" field (fetching the list of values in the database) it does not work anymore.

A simple example: I have 2 forms, one for the definition of a client, one for the definition of a sales person in my company. Each client is linked to a sales person via a look-up field. If a want to create a view that shows only the clients corresponding to a specific sales person, then it does not work. But if I change the type of the field (the "sales person" field in the "client" form) to a standard list (no look-up), it works.

Thanks for your help,

Sophie