Javier - Question 1 - in both forms and reports you can create aggregate function variables as:
vnext_rdg = (MIN(proc_code_nrdg)) IN fsched_file WHERE equip_code = .vequip_code Note that the set of parens surrounding the aggregate function are required. Question 2: You may have to re-write the procedure to close form 1 then do the updates on form 2, close it, and re-open form 1 to the appropriate record. Sami ----------------------------------------------------------- Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 913-915-1971 http://www.softwaremgmt.com ----- Original Message ----- From: Javier Valencia To: RBASE-L Mailing List Sent: Thursday, January 09, 2003 9:06 PM Subject: [RBASE-L] - Questions on forms, bugs... Question 1: I have a form in which I display information on a vehicle and I would like to display a lookup variable with the lowest (MIN) mileage for that vehicle based on information on maintenance intervals for different maintenance procedures stored in a separate file (schedule). Right now I use an eep to calculate this value on entry to the row.: COMPUTE vnext_rdg AS MIN proc_code_nrdg FROM fsched_file + WHERE equip_code = ..vequip_code Is there a way to define a variable in the form to do this, without using an eep? I seem to recall doing something similar this once upon a time, but I cannot remember exactly how. Question 2: >From a main form for a file that stores work order information (one), I call (via eep) a second form for a file that stores the manpower information for the work order (many), when I exit the second form, the eep calculates a summary of the labor costs and updates the work order file (using the UPDATE. command) with these cost and returns to the main form but the updated fields do not show the new values. In the past I have used NEXTROW, PREVROW in the eep to refresh the columns in the form but if I am in the last work order record, it will return display to the previous work order record ( NEXTROW does not do anything since is the last record and PREVREC will skip to the previous record). I believe that this topic has been discussed before and I was wondering if any one came up with a solution.what I really need is a "REFRESH FORM" type command (SAVEROW, SETFOCUS and RECALC TABLE do not work) or any other procedure that would force the main form to refresh. Thanks in advance, Javier Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX
