oilman

Thanks Quene

Hi all that the problem. When the match field is populated then the relookup works. But when the match field is empty,the lookup field that populated does not change, the relookup does not work. I have even included a empty record in the db where the lookup ocurr. Thanks Lionel

Hi I have tried relookup from the Records menu and the second field does not go blank when the first filed is empty.

Thanks transpower But that is not acceptable because the pop list is base on another database because different companies add abbreviation to the industries standard name for the welding process. If one company changes the pop up list than that section of the program will not work. Lionel

Hi all My welder's qualification form has two colunms for entering two different welding processes. When a process is chosen from a pop-up list, Two other lookup fields are populated. Sometimes a welder is qualify using only one process and sometimes the operator populates the second process field invertly and then goes back and delete the process but the lookup fields have been populated. I have tried doing a relookup but i must not understanding which field must be relookup because the lookup fields stay populated. How can i unpopulated the lookup fields. Thanks in advance Lionel

thanks Queue

Hi all Have a solution where i use the menu magic techinque to display and hide a menu. I added a delete record button to the portal and wrote attached a script to delete the record the user wants. The script works until you get to the delete record request. Nothing happen. I even attach the button to another script that call the delete record script. This works until it comes to the delete record request step and then nothing happens. There must be something i am missing because everything i tried works until the script comes to that step' I attached a simple abbreviated copy of the program Thanks Lionel weld.zip

Hi Karen E-mail me your address and i wil ship book the next day Lionel

Hi Karen If you can not get in touch with Bob- I have a copy of Scriptology i can loan you. Lionel

Hi Schotja I am fairly new to FM7 myself but i have done what you want to do. "When a new record is created in CmplxFile1, i want a new record created in simplefile2, automatically with the exact data from the two fields populating the records in simplefile2." in the relationship box, choose CmplxFile1 on the left side and Simplefile2 on the right side and check the box on the right side that states "Create New record in related file." Write a script and use the set field command to populate the two fields that you want. I hope this helps and i think i got the relationships right, if not, just reverse them. Lionel

Hi jason When you created the relationship, did you check the box that states "Create record in related file". Write your script useing the set field command Lionel

Hi Grant Use a portal to dispaly the records you want. Lionel

Hi Fitch The input is done from a dialog pop-up and the operator has been known to press the "OK" button before enter information in the required field and then says the program is not working. So i thought i would send a message telling then that they did not enter any criteria in the required field. Thanks Lionel

Thanks for the insight and the script, Vaughan Lionel

Thanks for the insight Lionel

Hi all I Have a portion of a script that is not working and i cannot understand why. Would someone look at it and tell me why. Allow user Abotr [off] Set Error Capture [On] Set field [g_drawingno, ""] Show Custom Dialog (Message) One button the "OK" Dialog has an input Field (g-drawingno) Go to layout [main] Enter Find Mode Insert Calculated Result[drawing_no,g_drawingno] Performd Find If[ Status(Currenterror)=401] Beep Show message (message) One button"OK" Show all Records go to layout (menu) Exit Script else If (status(Currenterror)=400] "Find criteria is empty" beep Show mesage (mesage) One button"OK" Go to Layout (Menu) exit script endif endif Perform Scrip The status currenterror = 400 is being ignore by the script Any ideas why Thanks Lionel One more day closer to retirement Version: v6.x Platform: Windows XP

thanks Queue

Hi all I have a portal that i want to use for finding drawing number. I have create a simple script that would goto related records Goto to Layout Main Goto related records (show only related) And attached this to a field in the portal. Put when someone picks a record the first record in the portal is shown, no better which record is chosen. I have create a self join relational to create the portal and the related record script is base on this relationship, What am i going wrong. I an using FM 6. Thanks in advance Lionel

Hi stanley Must be getting old- I thought i had tried that - but went back to check and i had not thanks, works perfectly Lionel

Hi stanley i did that and it still does not work Lionel

Hi all I am trying to get the portal to sort by employee last name after finding which company they are working for.Press the button in the upper right corner to goto the layout for the portal. The view layout sort properly but the portal does not. What am i doing wrong. Thanks in advance Lionel company.zip

Hi kristen What i do is use the set field command to sent the information to a global field into the db that i want to do the find and then use the insert calculated results command in the find mode. works ever time Lionel

HI LEONARD I have encounter this when i have tried to exit a record before completeinh the index field. The field you indexed on must be completed first before moving on. Lionel

thanks vaughan

Thanks lee Lionel