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