Repeating calculation field lookup

[Echo33029]

It's been a long time since I had to use a repeating field so maybe I am just a bit rusty.

Two fields in a line items table, ItemID and ProductName, both are repeating fields with 10 repeats. ItemID is defined as a number field, and ProductName is defined as a calculation field with a value that is calculated via a relationship between ItemID in this table to the ItemID in the Products table. The ProductName field is not being returned with this setup. If I change the field type to Text instead, it all works fine. What am I missing.

Thanks for any help.

Echo

Edited September 24, 2005 by Guest

[Paul de Halle]

Difficult to tell without seeing the solution. But it would suggest that the ItemID in the Product table had been set to a Text field. As a general rule both fields on either side of the relationship need to be the same type. Either that or there was text data in the ItemID field.

[Echo33029]

Paul, thanks for the response. HOwever both of the ID fields are correctly set to be number fields. I am pretty sure that I was able to do this back in version 3.

Any other suggestions are welcome.

Echo