Hi All,
I'm trying to do a relationship between two tables that looks like these:
Table1
Company Code | Name | Sales
12345 Comp1 $25
UEB213 Comp2 $35
Table 2
Company Code | State
12345 FL
However, I get the error that "Cannot convert value of type text to type Number". (See attachment)
Is there a workaround?
Thanks
Regards,
Fernando
I'm trying to do a relationship between two tables that looks like these:
Table1
Company Code | Name | Sales
12345 Comp1 $25
UEB213 Comp2 $35
Table 2
Company Code | State
12345 FL
However, I get the error that "Cannot convert value of type text to type Number". (See attachment)
Is there a workaround?
Thanks
Regards,
Fernando