Robert Schumann
asked on
Table Lookup-Combo Box, field text displaying as number in a report
Hi
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.
Any ideas?
Thanks in advance
Bob
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.
Any ideas?
Thanks in advance
Bob
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ed, ita created list.
What I just discovered was the "Project" text field in the Projects table was indexed YES (Duplicates Ok). I changed to NO and the parameter query ran. Does this make sense?
What I just discovered was the "Project" text field in the Projects table was indexed YES (Duplicates Ok). I changed to NO and the parameter query ran. Does this make sense?
ASKER
Rey - adding the Project table to the query with a join between the Projects worked.
THANK YOU I accept this answer.
THANK YOU I accept this answer.
Just few clarifications.
What is the data type of the field that has the look-up value list? Is that field look up the value from other tables or from a created list?
Sincerely,
Ed