JitseSchaafsma

That did the trick but ........ is this a bug ...... is it stil there in FMp7 ?? Jitse

Please have a look at the attached file (parent.fp5 and child.fp5) Thanks Jitse

Thanks, but that did not work. Offcourse, i can make calculation fields, but any other suggestions are more then welcome !! jitse

In addition: When i manual zoom the window and unzoom again the related field displays the correct value. If i create a calculated field that copies the value of the related field the calculated field is updated correct. Oh yes : FM 5.5 developer OS X 10.2.8 Weird Jitse

I have a related field on my layout that is not updated when the "mother record" is updated. The specific field has allow entry not checked. If i make a copy of this field but with allow entry checked the updated works perfect. I have tried numerous solutions redraw screen goto related record empty chache Please help me out on this one Thanks Jitse

I have a set of databases connected through different relations. Each database has a startup script that is launched when the database is opened. So fa so good. Now i have one database (it is a child database) of which the startup script is not launched when the database is opened during a relation calculation in my main database. All other child databases work perfect. If i open this database directly the startup script is launched. I have tried 1] renaming the script and resetting the document setting 2] recover the database 3] pulled out my last hair (that wil not do the trick anymore) Please advise on this thanks Jitse

Thank you for your attention and answer. Your suggestion is a valuable solutions. In your solutions the user can select the apropriate help document using a portal. In our solution the user selects with a list. After coding your example we can compare, agin thanks. And guess what : we already have build screenshots in our help as a guiding for users great. Thanks Jitse

I want to build a smart help system in my application. After the user has entered a number of keywords he/she will be able to select from a popup list a number of help files that matches ALL the keywords (so an AND search). This is what i have done. 1] I have made a help file. Each record contains a help header (for example How can i find a specific order) and a text field containing the help description. In addition i have a calculated field that contains all the words from the text field. 2] This file contains a number of help records. 3] The user can enter maximum of 5 keywords. 4] I have 5 keyword_index calculated field that contain the first, second, third and so on word of the keywords. 5] I have five relations from each keyword_index to the calculated field form the help file. 6] I have 5 valuelists based on the above relations containg the record id of the matched records. 7] using a script i find the recordid that are in all the 5 valuelists (of course i have taken care if the user enters only a limited number of keywords). 8] Based on the found recordid's a menu list is created which the user can use to select the needed help file. This works fine. But my Q is this : Can this be done in a more simple way. 1] Can i make a calculated field that does the script job ( i am using FM 5.5 !!) 2] can i use smarter relations ? Any suggestions are welcome Thanks Jitse

because of the extend statement, me dumbo <smile> jitse

thanks ! but why is the if statement not working? a bug ? jitse

Thanks for your interest. The reasoning is this. Actually the container field is a graphic element. When on screen it is coloured, when printed it is a black an white picture. so i have a calculation field X=if(printtoscreen = 1 , Y , Z) Y and Z are global container fields. X is a container field. I want to use a calculation and not a script because a (large) number of fields are involved. All fields have 10 elements. Any supported is appreciated Jitse

Well thank you. But... i should have mentioned that X and Y are containersfield with graphic elements. Any suggestion then ? much appreciated. jitse

Surely i am missing something but how can i do this X is a global repeating field Y is a caclulated repeating field How should i set up the calculation so that Y = X. The obove statement only copies the first element and not all. Or shoul i use a script for this ? Thanks jitse

How can i re-enter an installation code and user name in filemaker 5.5 (without new installation offcourse) On a Mac ? On a Windows ? Thanks Jitse

Thanks Steve, in the mean time i have contacted FM to info on upgrade for my FM 5. I am waiting for their response Greetings Jitse

because i want to test a filemaker application tat is based on sharing files through my network i need two different license packages. well i do have filemkaer 5.5 developer for OS X. i also have a Filemaker 5 pro for classic. Now i want to upgrade this 5 pro for classic to 5.5 for OS X. I really have no idea if that would be a free upgrade. so what i wanted to do was to locate an upgrader form 5 to 5.5 or the 5.5 imstaller. My problem is that i can not find an upgrade installer nor the 5.5. my Q is can i upgrade my 5 pro for classic to 5.5 for OX. where can i find the installer ? Thanks Jitse

thanks i feel like an idiot !! jitse

My question is about how to trap user cancelation of an operation. 1] i have made a script that does some operation in a related file with a subscript. 2] this operation takes some time, the user can cancel with the command dot command. 3] When the use has canceled the operation the related file is opened where the script was running. So my question is 1] how can i prevent user interuption 2] if that can be done how can i automatically go back to my main file when the user has cancelled a subscript in the related file. Thanks a lot for helping me solve this critical issue in my runtime application Jitse Schaafsma

I have a text field containing some numbers seperated by carriage returns (so they are displayed as a column). Now my question is how can i format a text string to a number. For example 12356,00 should be Eurosign 12.356,00 So what i actually want is to have the number formating as standard in filemaker used on my text field. Is this possible? Thanks Jitse

Thanks for your response. Maybe i do not understand your answer completely. I my situation i am not able to sort because of the valuelist ( a valuelist is sorted alphanumeric i think). could you please elaborate a bit more on your suggestion. Thanks a M Jitse and i am using FM 5.5

Let me begin. To avoid all those nasty habbits of the standard portal i use valuelists and my own script based scrollbar. This technique has earlier been suggested in this forum, it works great. Now i have a question concerning how to sort in the portal. 1] I have a child database with the following fields Class Name Age RecordId 2] i have a parent database with a (global)field SearchClass. 3] I have a relation between SearchClass and Class in the child database. This relation is called Contacts. 4] i have a valuelist based on Contacts that contains the recordid of the records ; ContactsVL I have calculated field ; DisplContacts=valueListitems(database;"ContactsVL") 5] I have a calculated field : ContactsinPortal=MiddleWords(DisplContacts;startindex;endindex) 6] i have a relationship between ContactsinPortal and recordid in the cchild database ContactstoShow Now you can see that based on startindex and endindex a number of recods are shown in the ContactstoShow portal. sorry for the long story. Now my question is; what should i do to be able to sort the records in the ContactstoShow portal on Name or on age. Should i build different Valuelists? Should i build different relations anys suggestions are welcome because now i am stuck. Jitse

I want to build calculated field from a user input field that is a text field. Now this calcuated field is later used in a relation and a value list. How can i easily remove all of the word delimeters ( . , ;, etc etc) For example when the user fills in "monkey,car.house garden" i want it to be monkeycarhousegarden. Should i use mutiple subsititue statements. The other question is : where can i find the list of word delimiters ? Thanks Oh yes ; still working wih F 5.5

Thanks Lee, To answer the why Q ( and why manually is not an option). The value list contains materials that clients can order. Now i want to include in the value list the materials that clients previously have ordered and all the materials that are available. So for each client the value list will be different and manualy filling is not a option. I the example i have used: The user of the database is taking order of a client. This client has previously ordered aaa and ddd. Now suppose the clients orders aaa and ccc. Then the next time this clients makes an order the value list should be aaa ccc ddd. Any ideas Jitse

The great thing about value lists is that it automaticly removes multiple instances from the value list. But, now i have a need to keep multiple instances in my value list. Even more, i also want the list to be sorted alphanuerical (not ASCII). Suppose the relation that is used delivers the following records to the valuelist: aaa bbb ccc ddd eee aaa ddd Normaly the valuelist would be aaa bbb ccc ddd eee but now i want to be the value list aaa ddd aaa bbb ccc ddd eee Does anyone know how to achieve this in FMP 5.5 Thanks a lot Jitse Schaafsma

No doubt this has ben covered before, i can not find the thread. I want to create a valuelist of which the second field (not sorted on) is a summary field. Obviously, this second field can not be indexed and fm says it will not work. Does anyone have a workaround on this problem. FileMaker Version: 5 Platform: Mac OS X Jaguar