Question

lookups not running on table change

Forms Version 10

Updated October 3, 2017

asked on October 2, 2017

We are creating a form that execute 3 SQL procedure. First it select and filled a table with only the classes that are for a specific semester, second it populate the same classes dropdown will all the available course for the major. These 2 procedures run without issue.

The 3 procedure, need to run when the user changed any classes for the dropdown, it should be filling the course id and the credits based on the class selected. This part is not being execute, what I'm doing wrong? how I can make this lookup to execute?

We are running Forms 10.2.1, below the lookups and also screenshot of the form:

Initial Procedure: add the new rows

Second procedure: add the additional course's name to the dropdown (without adding new rows):

3 procedure: Lookup when the course name changed (this is the one not working):

Screenshot: in this sample, only 4 classes returned from the 1st procedure, then the 2nd procedure filled all the available classes. When the user changes the course, the 3rd procedure should complete the course id and the credits. Any help will be appreciated!!

0 0

Replies

replied on October 2, 2017

Looks like you might have conflicting lookups. Both the first and third lookup rules act on the Course # and Credits fields, so they would conflict with one another and the first would likely override the last one.

Try removing those from the first lookup rule. The third rule should populate the values in response to the first lookup rule anyway, not just when the user changes something.

0 0

replied on October 3, 2017

Hi Jason,

You were correct, I removed the Course # and Credits and the 3 procedure update those fields on initial load and also after any change.

Thanks,

0 0

You are not allowed to follow up in this post.

Question

Question

lookups not running on table change

Replies

Sign in to reply to this post.