You are viewing limited content. For full access, please sign in.

Question

Question

Forms lookup rule ignoring one person

Forms
Updated November 2, 2018
asked on November 2, 2018

I have a lookup rule in a form where:

  1. If A=(table User ID) 
  2. B=(table Last Name) 

Fill First Name with (Table) First Name.

This works fine EXCEPT with one person. They never appear! 

 

BUT, this person does show up when:

  1. If A=(table User ID):
  2. Fill First Name with (Table) First Name.
  3. Fill Last Name with (Table) Last Name.
     

I am stumped on why the person appears with the latter rule combination and not the first. 

 

0 0

Replies

replied on November 2, 2018

Success. My database guy found two spaces after the person's name. Thanks for you input!!!

1 0
replied on November 2, 2018

I was experiencing something like this just yesterday. See if there are 2 rows of data that are returned when you put in the criteria for that 'one person' you were referring to. See how it looks in the table when you query it. 

In my case, there were 2 result rows and Forms made one of the fields a drop down. You could make your fields NOT read only and then place your cursor over the fields after the lookup. It one of them turns into a drop-down, then you have more than one row of data as your lookup results.

My solution was to make my field NOT read only so that the user could select the criteria to return only one result.

Hope this helps,

 

Chris

0 0
replied on November 2, 2018

Great Suggestion. When I do a query, all columns are returned except for his last name.  I am waiting for my database guy to review this entry.  

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...