Thank you for your post.
We are in a dilemma here... It's difficult to determine what is the problem without seeing the file, but seeing the file is going to be difficult.
There is no limit to the number of records and fields one can create in a file. You are limited by the file size limitation. It's been a while since I've worked with FileMaker Pro 6, but I do remember that the file size limitation was 2GB, and this limit was raised to 8 Terabytes in FileMaker Pro 7. Still, your file is 100MB so the point is moot.
Have you worked with a clone of the file? If so, are you able to add fields and/or modify relationships?
I haven't encountered a database file with 6566 fields in one table. What type of application needs that many fields in one table? Can any of the fields be offset to another table?
Other than that, FileMaker Pro is seeing something in the table it doesn't like. Again, it is difficult to determine without seeing the file.
Thank you for your response.
I did try adding fields to the clone copy and had the same results, i.e., the program terminates when I attempt to add/edit a relationship.
We are using the program to quote/print contracts for burglary, fire, video, and access control systems that we install.
I feel helpless, because we're now at the stage where someone needs to look at the file. In particular, our Testing department wants to see the file. Is it possible to put the clone on CD and send it to us?
If so, I have sent you a private message with a contact in Technical Support who would receive the file.
Thank you for your interest in this problem. There are aspects of this database that could be moved to another database and then use relationships to put it into the main database similar to what we are currently doing with our parts pricing, standby current and alarm current fields. We have been working on this quoting/pricing database for eight years and will contact you via email concerning whether or not the owner/president wants to send you a copy of the database structure.
As another test you can also try the following:
-Export your data (.csv, .txt, etc)
-Drag the exported file into Filemaker so that it converts the exported file into a generic FileMaker database
-Try adding new fields
Since the behavior still exists in a clone, we can assume the issue is still attached to that particular database/layouts. Creating a generic FileMaker database with the same data can help narrow down the issue.
I was not able to export the data to a tab delimited file - when I asked the program to move all fields, one field (the last one) was in the destination set multiple times (>100). When I tried to clear the repeated field, the program terminated.
We would like to send you a copy of the cloned database, but I either did not receive your private message or I do not know how to retrieve it. (I am new to this forum and may not understand how things work).
Do you think a newer version (server version) would solve this, or would it just be propagated when it reads the data file?
Thank you for taking the time to assist us with this problem.
First, I edited your message and removed the reference to your email address. We are very committed to privacy on this public forum, and we do not want users to copy personal information.
Second, I saw your recent private message and confirmation of where to send the file.