I have several calculation fields that are pulling information (text) from related records in another file and combining/formating it so that we can export it to another program. My problem is that although the fields worked when I created them, only some of them are working now. I have checked the storage settings and it is not storing the calculation(infact I can't change that) I have gone back to test the calculations and there don't seem to be any problems, so now I am stuck. Any suggestions as to why these fields would be blank?

maybe there is no valid relationship for those fields to return data.

can you post the files, so others can see them?

I figured it out it was an I-D-10t problem. My calculation was Left(Product::Description, Position(Product::Description, ". ", 1,1))and in some the Product descriptions there were commas in stead of periods (data entry is great)so it wasn't completing the calculation. Thanks for your help though.