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, 200520 yr by Guest

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.

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