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

Question

Question

Database lookup not populating Forms field

asked on May 17, 2019

This one has me stumped.  I am doing a lookup using zip code, year and month for GSA travel rates.

All the database columns will populate Form fields except one column, lodging.  Screenshots show the table and column schema and the returned results for the query.  Also included is the Lookup rules and the output to the form. 

 

As you can see, Meals is populating Meal Total.  FiscalYear is populating GSA Lodging(Currency).  Lodging is NOT populating Lodging (Number-2 decimals).  County is populating LodgingString.  I also tried to populate Lodging with the Meals column and 61.00 populated in the Lodging field.

 

Any ideas?

SQL.PNG
Lookup Rules.PNG
Form.PNG
SQL.PNG (19.12 KB)
Lookup Rules.PNG (34.32 KB)
Form.PNG (24.17 KB)
0 0

Answer

SELECTED ANSWER
replied on May 17, 2019

Figured it out.  I did not include month in the where clause.  It was returning multiple values for lodging.

0 0

Replies

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

Sign in to reply to this post.