I am converting a FM5/6 database to FM7.

In the original I have a Calculation Field (Times used) that gets the "Count" of how many times a serial number is in a field (Serial Number).

When I converted that one Database the same calculation works.

This is the calculation of the converted file. "Count(Serial Number of Software::Serial Number)

However, when I try to recreate that calculation manually in the new database it does not work.

When I recreate the calculation manually it ends up looking like this.

"Count(software::Serial Number)"

The problem is in the new database it always 1 no matter how many time i duplicate a record.

I have indexing on for the serial number field and in the Times Used field I am calculating the value is Unstored.

Thanks! in advance for any help.

Are you sure there is a relationship on the Table Occurance Graph between Software and the layout's table?

Try dropping a portal to Software on the layout with the related Serial Number field. Do you see related records?

Thanks. I wasn't aware that I have to have a relationship when doing a count within the same table. after I created a new table and related the serial number field it worked perfectly.

Those multiple table occurrences are going to be my down fall. Someone needs to write a cheat sheet on when creating a table occurrence is necessary.

But thanks for your help.

grumbachr

There is a section in the Migration Foundations and Methodologies tech brief that does a good job explaining table occurances (some light reading.)