falcon

The field is a number field that has auto enter serial number. I did not have the prevent modification number checked before. Now I do. I wonder how important that is.

I have a related file that is supposed to give each new record a serial number, incremented by 1 from the previous record, whenever the record is created. I discovered that some records were being overwritten when new records were created. When I checked my field definition for the serial number I found the the serial number seemed to revert to a previous number. For examlpe, instead of reading "1200" as the next number, it read "680". This caused records to share the same serial number. My solution was to Check off the "prevent user modification" My question: Is there a bug in filemaker5 that may allow a serialized number to revert back to a previous number? I used this solution with FM4 and never had this problem. Thanks

I wish to be able to calculate a class average for percent attendance in a subsummary part, where I sort by class. The students do not all have the same number of days possible in a month. A summary field that gives me an average of student averages is not accurate because some students register or leave during each month. I can use a calculation field but only if I do my report manually, class by class. I wish to do the entire school, with each calculated class attendance automatically done. (The calculation field will calculate the school attendance properly but will not calculate individual classes that the report generates when I sort by class.) Any Suggestions?