Table Lookup-Combo Box, field text displaying as number in a report
Posted on 2014-02-07
I've a small db with only three tables. Projects, Vendors & PurchaseOrders. The Projects and Vendors tables are all text fields. The PurchaseOrders table has a few fields that are both Lookup-Combo Box and Lookup-Value List.
My problem is the text from the field that has a Lookup-Combo Box is transposed to a number in my reports.
There are two fields in the PurchaseOrders table that have a Combo Box control based on a query of two text fields in the Projects table. Both fields are Text, but one has a project title and the other the project number.
If I create a parameter query to the PurchaseOrders table, and the parameter is for the project number field, the query will run but will not show the records.
However if I create a parameter query based on a table field that is a Lookup~Value List, it will work.
In a report, which is based on a query or directly to the table, the field that is a Lookup-Combo Box will not display correctly, the project description is numeric, ie: 19 or 201, etc.
Thanks in advance