J. Odijk
|
| Posted: 05/21/2002, 8:25 AM |
|
Hello,
I have a problem with the join option of a label.
I have a field in a form where I want to show a company name.
The table I use for this form has a foreign key named company_id which is related with the table were the company_name is in. There are several company_name records in the table (all with an unique company_id).
I have used the join option in the field properties (label) with this settings:
Table: Project_Company
Primary Key: Company_id
Showing: Company_name
When I want to view the page I get the following error-message:
Types in Expression don't match (translated from a Dutch Error-message)
And when I make the field a list box it does work and it does show the company_name, but the list also contains all the other companies.
Can it work as a label? How can I solve my problem?
Thanks in advance!
|
|
|
 |
Nicole
|
| Posted: 05/22/2002, 12:04 AM |
|
Hello,
please check the type of Label field in CC you join other table to. The type of primary key in joint table should be the same as Label field type set up in field properties on common tab in 'Data Type' list.
|
|
|
|
Jasper
|
| Posted: 05/22/2002, 2:22 AM |
|
Yes it works!
Thanks!!!
Jasper
|
|
|
|
|
