Question

New Table Not Showing in Lookup Rules

Forms Version 9

Updated April 10, 2014

asked on February 24, 2014 • Show version history

We have just added a new table to a database we are doing lookup rules on. I performed an update on the Data Sources pane for the database so it the table would show when selecting "Show Details". I have also made sure that the business process has access to the database. When I go to the Lookup Rules for the form and select New Lookup Rule, I can select the database, but the table does not show up. All previous tables show up correctly. I have tried logging out and back in which did not work. Is there a part of the process I am missing to get the new table to show correctly?

1 0

Answer

APPROVED ANSWER SELECTED ANSWER

replied on February 25, 2014

This looks to be a bug when using IE. As you've found out, using other browsers work fine in that once you update the data source, the new tables appear when configuring lookup rules. The workaround for now would be to use another browser until we get this issue addressed.

2 0

Replies

replied on February 24, 2014 • Show version history

Check if you already have a lookup rule that is pointing to that SQL DB and table, Forms will not let you create a lookup to the same table in two places. If the lookup already exists, create your new rule under that lookup.

0 0

View 3 previous replies

replied on February 24, 2014

It is a brand new table so there are no other lookup rules pointing to it. I am the only that sets up forms, so I know no one else has created one. For the form I am working with there are no lookup rules at all.

0 0

replied on February 24, 2014

I just tried a different browser and it shows up. Does the browser cache that information? The browser I was using first was IE 11. I then tried Firefox 27.0.1.

0 0

replied on February 25, 2014

Were you in separate browser tabs when you updated the data source? If you have the lookup rules page in one tab and you're updating the data source in another tab, you'd have to refresh the lookup rules page to get the updated information to show up.

0 0

replied on February 25, 2014

It was done in the same tab.

0 0

APPROVED ANSWER SELECTED ANSWER

replied on February 25, 2014

2 0

replied on April 10, 2014

Had the same issue, simple work around is to log out of LF Forms, clear your IE cache, close and reopen IE.

0 0

You are not allowed to follow up in this post.

Question

Question

New Table Not Showing in Lookup Rules

Answer

Replies

Sign in to reply to this post.