sunbird

Hey, thanks so much. I saw that but somehow thought it was just to select between tables, and ignored it after that. I appreciate it - that is so much better!

What do you mean, 'in the last sort order of the Define Database Fields list'? In my Define Database window, the fields are all in the desired order, but once I get to the Export dialogue box they are all listed alphabetically. That's the problem - I have something like 300 fields and they are all listed alphabetically. Does anyone know how to change the display so that the fields in the Export window are in the order in which they appear in the Define Database window? If so, I'd very much love to hear how. Thanks.

I am trying to export a series of fields to Excel in the same order in which they appear on my layout (which is, incidentally, also the order in which they appear in the define database window). However, Filemaker displays all fields alphabetically by name in the export dialog box. I imagine that there has got to be an easier way to export a group of fields than picking through the alphabetized list and then pulling each out one by one, but I can't figure out how. Is there any way to get the export order to automatically match the existing field order? Many thanks in advance.

I am trying to write a script that performs a find using values entered in checkboxes. For example, for a field which holds languages spoken (English, French, Spanish, etc.) how would I perform a find for all records listing French? Many thanks in advance,

Thanks, I didn't notice that.

I am new to Filemaker, and getting pretty frustrated trying to figure out to get it to do what I need it to. I'm a graduate student and need to get the data in my database analyzed so I can start writing my thesis, but am stumped at the moment as to how to do this. I feel like I have too many questions to post them all here, and none of the Filemaker books or online documents I've found are really all that much help. I would absolutely love to sit down with someone knowledgable who lives in my area and to ask some basic questions. Do you know how I could find such a person? I live in Madison, Wisconsin. Many thanks in advance for any advice.

Ok, I'll try that - thanks!

Hi all, I'm new here and to Filemaker, hoping someone can help me out... I am trying to analyze the results of a couple hundred surveys. The results of each survey are stored in a single record of a single table. What I want to do is perform calculations involving all the survey results, and I need to do things slightly more involved than simple sums and counts (more advanced than what you can do with a summary field, in other words - at least as far as I know). For example, one question might ask if the person plays soccer, football and/or baseball, and another ask whether the person lives in Toronto, Austin or Los Angeles. I want to be able to figure out things like the total number of people that play football, the number of people that play both football and baseball, the number of people that play soccer and live in Austin, etc. I am pretty stumped as to how to do this. As far as I can tell, this can't be done with calculation fields by themselves (can it?), so I was thinking to just set up a script to cycle through all the records for a given table (= all the surveys), perform all calculations and then dump the values in a separate table at the end. However, I can't even figure out how to tell Filemaker to manipulate the records one by one. My programming experience is mainly in C (which I am decent at that though not stellar), and I'm feeling pretty lost at the moment trying to work with Filemaker. Any help would be much appreciated...