Please bear with me, this is tough to explain. I am using 6.0v3 on a Mac running 10.2.1. Everything was fine until I added the 8192nd record. With 8191 and a total line in list view, everything works fine. When I added five more records and sorted, the last four records and the total line disappeared, to be replaced by a copy of the first five records. They aren't really there, though. Selecting one of them and switching to form view shows the correct record, but I don't see it in list view. Table view works fine. It looks like there's a wraparound situation at 8192 records and I suspect it's a bug or program limitation since 8192 is 2 to the 13th power. Bad luck, I guess. Anybody have any info or ideas?

Hm. I just tried this by making a simple DB and adding 8191, 8192, and 8193 records, only fields defined being a autogenerated unique number and a total, did a simple sort and looked in all 3 views. Didn't find the bug. Any more description of the problem? Total file size?

Bevin

The file size is only 2.1MB. There are only 8 fields. Are you running on a Mac or PC, CyberSport?

mac, but 10.1.5

still am pouting about paying for upgrade until i am so jealous of all my friends who have moved to jaguar that i can't resist any longer.

Oh, go ahead. I coughed up the bucks and I'm not sorry. I emailed someone else a copy of the file and he couldn't replicate the problem. I have a couple of ideas on how to proceed if it's not a normal occurrence with the program, but it'll be at least a week before I can try them. Guess I'll use up my one free support call tomorrow.

You're gonna love this, CyberSport! I called FileMaker today and the tech had me create a new layout while on the phone. It worked perfectly, of course, so I ended the call and spent some time matching the layout exactly to the problem layout. After I was done - the problem was back! I checked it out step by step and here's what I came up with:

Everything works until I move the lines between layout parts closer together. More precisely, when I move the trailing grand summary up closer to the body, the problem appears and when I move it back, the problem goes away. My original layout had the lines very close together so the problem came up as soon as I hit the right number of records. When I created a new layout, there was no trouble until I moved that line up in layout mode. I went back to my problem layout, lowered the line about a pixel and voila! Problem solved. I moved the line back and forth a couple of times to confirm the results and it happened every time. That was a fun one. Let's not do it again soon!

wow. that's quite amusing (well, unless i had been YOU!)--some of the quirks of this system are enough to make me pull out my hair. did you have any data IN the trailing grand summary? shaking head...

Nope. Just two simple field totals. On another topic, can you recommend any good FM Pro 6 books?