Sounds like you should re-structure your database so that you have a set of 25 records with one such data field instead of 25 fields in one record. Then you only need a few summary and calculation fields to do this.
in this case, i am getting the data from an outside company in their format.
so, i am at their mercy to some extent.
i cannot think of a way i could restructure without spending hours with the original spreadsheets in excel
The fact that your data from an outside source comes in this structure shouldn't prevent you from restructuring your data after you have imported it in to filemaker.
so, in the case that i have...
four similar tables, each with 4500 records, each of which has 25 fields, and on all 25 id like to know the % of each type of value (3 possible), and be able to relate those 4500 records to other tables...
what would be your suggestion?
id really love any input on a more effective method. im a relative newb, and every bit of data i produce just yields more requests for more data.
thx for your reply!
What type of file are you importing from? The file type may dictate which option for splitting up your data into related files you need to use and whether you do this before or after import.
For your existing data, you'd define a new table and relate it to your current table and then run a script that moves your data field by field and record by record into your new related table. You'll need to determine an effective relationship for linking your two tables. A serial number field defined in your current table is almost certainly your best bet.