Eclipse

It doesn't seem so, unfortunately, i have been seeking the same answers...

Thanks everyone for the tips andknowledge! It's gonna be a long weekend, i'll have about 150+ scripts to go through. It almost makes sense to upgrade to DEV just for this task, lol.

thanks for the quick response Steve. FM Dev can do so, but does FM Pro 6 have this capability as well? What about FM Pro 7?

I have a database in Filemaker 6 which contains the following files: "members.fp5" "events.fp5" "feedback.fp5" What I want to do is change the file name of the "members" file to "contacts.fp5" The question i have is, since there are scripts, calculations and maybe even some formulas contained in the "events" and "communications" files which relate to the "members" file, will they still work? Does Filemaker 6 know to automatically update the referred-to filenames within the dependent scripts when/if i change the "members" filename to "contacts"? Thanks!

thanks for the suggestion Transpower - actually i just figured out a workaround, here's what i did... Searched for several different zipcodes on Yahoo Maps, noticed that all search strings were exactly same except for 5 characters and those 5 characters were the zip code, so i made two global fields, the first with all the text in the search string before the zipcode, the second with all the text after the zip code, then created a calculation field that looks something like this URL_a&zipcode&URL_b it returns the needed search string, then created a button on the layout that performs an open URL script which is set to open the url in the calculation field- LOVE this program!

I know this is a lot to ask of anyone writing plug-ins, but has anyone here ever seen a plug in that can return data from Mapquest or Yahoo Maps, or a simnilar service, based solely upon zip code? Our database manages thousands of kids across the country who promote musical acts for us and when accepting new members, we try to accept the ones who are close to major cities, not in the middle of West-Jabib so when someone lives in a city we have never heard of, we have a quick launch button on the screen that opens Mapquest in a browser window, but then we have to manually enter the zip code to find exactly where they live. It would be nice to just automatically pull that data from either mapquest or yahoo maps or a similar service and it be instantly visible on the screen in a small container field. Has anyone ever seen anything like this before? Thanks!

There's also an amazing plugin for FM ver 4.0 and higher made by CNS called SMTP-IT. We use it on our databases to email members. It's relatively cheap and it's abilities are almost limitless. We're even able to putt customized data from various member's records and incorporate it into their outgoing emails. It sends mail directly from filemaker, so there's no need to have 500 composed messages on your screen that have to be manually sent or queued, etc... You can check it out at http://www.cnsplug-ins.com/products.htm?product=SMTPit Hope it helps

E Springer thank you very much. Your solution worked perfectly. I was meddling around with the IF statement yesterday, but having problems, I tried to work something with CASE as well, but couldn't figure it out. Your proper use of the CASE statement along with the chenge in the relationship workled perfectly. Thanks! I posted the corrected file here in case others have a similar problem and looking for an example to look at. FM_problem.zip

Hello again, made a quick example file i attached hoipefully it will help explain exactly what i am trying to do. In the file "member.fp5", there are six records with the value "001 New York" in the DMA fields however only 4 of them have a value of "Active" in the Status field. In the file "import.fp5" when looking at the first record, since the value of that record's DMA field is "001 New York" i need it to give a count of 4 instead of 6. It's showing count of all related records and i only want it to show the count of all related records that have a Status of "Active". Please help Thanks! Chris FM_problem.zip

our upgrade from 5 to 6 was almost un noticed by our users. The upgrade went exceptionally well. Upgrading from 6 to 7 however is very scary sounding and we have not yet done it.

Hello, i have been trying to figure this out for a while now, hopefully someone can help me... I have 2 files, "import"fp5" & "members.fp5". Each file has the following Fields and values: Field Name: Member_Status Values: value list - choices: Active, Inactive, Suspended Field Name: DMA Values: value list - 001 New York, 002 Los Angeles, 003 Chicago, etc... What i am trying to do is create a calculation field in the "import.fp5" file that can tell me how many records in the "members.fp5" file have the same DMA as the current record in the "import.fp5" file BUT ALSO only have a status of "Active". I have built a relationship named "count_qty_mbrs_same_DMA" from "import.fp5" to "members.fp5" based upon the DMA field. Also, in the "import.fp5" file, i have created a calculation with the following definition: Count(count_qty_mbrs_same_DMA::Member_status) However, the calculation only returns the total quantity of records in the "members.fp5" file with the same DMA as the current record in the "import.fp5" file. For instance, if I am browsing the "import.fp5" file and the DMA value for that current record is "001 New York" , then it will correctly show that there are 12 records with the value "001 New York" in the "members.fp5" file, however I can't seem to get it to tell me how many of those related records have a value of "Active" in the Status field. It's confusing, because i do not want to have to do a find script, it needs to be a calculation with unstored results. I hope i explained this well. Thanks! Chris