Dynamic Queries/Views?
Dynamic Queries/Views?
I have created a view where I can select the rows that I see using a constant as in:
show all rows from ProductCatalog [AccessCode == "Terracycle"]
However, what I really want is instead of using a constant (in this case "Terracycle") to instead use a value from another form, such as:
show all rows from ProductCatalog [AccessCode == UserAccessCode[Varname=="Var1"]]
BUT THIS DOES NOT WORK! What am I missing? It is a basic feature of SQL to allow a user to select rows based on some dynamic values, can ZOHO do this??? I am really hoping to get some answers as I need to build my application quickly! Thanks so much for any support.
-dm-
dmiller2u