Hi Xiuhong

If I run the lookup rules as you had shown above, it does work, but as soon as I add the "condition" to Rule 2, "Where Industry equals Industry", rule 2 stills runs correctly and draws back a subset of the data to populate the table, but Rule 3 which was unchanged no longer pulls back the data to the drop down field. I did check to ensure that the files drawn back from Rule 2 did indeed include data to be included in the Drop Down field.

FYI, the field types are Single Line, except for the Drop Down field.

I added a condition for the first rule as you and I can still get the correct list for the dropdown(http://screencast.com/t/MG4gc8S8aTE. Can you check if you temporally remove rule 2 and just test whether rule 3 works when you fill the ClauseNumber with same data?

It's good to know it should work, but I'm not having any luck on my side.

I created a new table like yours and deleted Rule 2 and am just using the look up in rule 3 which is not working at all by itself. I manually enter the any of the DB values in Column 1, and no success. I have attached a picture below of the Table, Rule and DB for your review.

Try adding the property ('vo', 'e') to the field in the first column. I've had similar issues in the past and if the field that triggers the lookup is set programmatically, it needs that property. Just a thought!

Can you be more descriptive of where this would be, inside forms? I not familiar to this in DB terms. Picture would be helpful.

Thanks

Sorry! You can add it to the field using javascript. If the field that's being used to trigger the lookup is "table1-column2" you'd use the line below:

$(".table1-column2 input").attr("vo", "e");  //put the correct field id or class

Not sure that this is your problem, but maybe?!