field based on lookup on another field value

Applications Forms
#1

Hello, I am trying make a field display data using a select statement based on another fields value.
so for example, I have field1 with data, I want to make field2 display data based on lookup on field1.

This is different from a select box.

#2

Re: field based on lookup on another field value

What the types (Scriptcase) of field1 and field2 ?

#3

Re: field based on lookup on another field value

field1 should be integer. field2 should be text. For example i want to display this on a field:

select field2 from table1 where [value.of.field1.from.form] = field1

how do I get the value of field 1 from form?

#4

Re: field based on lookup on another field value

hello no answer yet?

#5

Re: field based on lookup on another field value

Basically, how do you show the CONDIMENTS value based on the categoryid ? (the picture below is taken from one of the examples on your website)

#6

Re: field based on lookup on another field value

Hi to refer a field, use {field}.

Or you can use an Ajax event to get it.

To do like the image, use the “Use lookup to display the field description” Option in “Grid Lookup” of the field

#7

Re: field based on lookup on another field value

thanks, using {} works well. You have great product but I think the help and the examples should be easy enough to understand for users who have little experience