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?
0
0