I'm quite new at Zoho Creator, I like it so far. I have a certain knowledge in mySQL and PHP but not enough to develop my own CMS. ZOHO is perfect in my case.

I'm building a simple data structure for a project I have with 3-5 forms to organize my data.

In one of them I need to create a drop down that contains only the results associated with the previous drop down.

In my example, I have 3 applications:

- Clients ( simple name of the customers )

- Filiales ( french name for branch )

- Panneaux ( french name for panel)

My Dynamic Lookup drop down I have problem withis in the form called Panneaux. What I would like is that the drop down called "Filiale" only shows the one binded with the "Client" selected in the previous drop down.

I've read most of the exemples or documentations as well as the forum but I can't figure out where my problem is.

In my form called "Filiales" I have to set the "Set filters" to:

Clients.Nom == input.Client

But when I do so, I get the error " In Criteria left expression is of type STRING and right expression is of type BIGINT and the operator == is not valid"

Errors shows when you do something wrong but I found none or slime help I found revelant in this matter.

I've checked if there was no way for me to make sure that all types of fields are the same but in "field property" the feature is greyed out since my drop down have been created using "Lookup" field type.

Any help would be appreciated.

I can share with anyone who would like to take a look but since I use a free edition, I can't make it public.

Henrik