Sorry, I misstated the problem. I have a form something like this: +-------------+------------------------------------+ | Key Fields | Production table fields | +-------------+------------------------------------+ |Personnel table fields | +--------------------------------------------------+ | Equipment table Fields | + --------------------------------------------------+ All three tables have the key fields (date and Crew) Each temporary table has all data for work crews for a selected date. The form opens with the cursor in the production field and tabs through them and then tabs to the first field of the personnel records for the current production crew.
I want to be able to tab through the personnel records for the current crew and on the last personnel field, determine if this is the last personnel record for the current crew. If last record then tab to equipment records for current crew, else tab back to first field in next row of personnel records for current crew. Then proceed to do the same thing for the equipment table and when finished with all equipment rows for the current crew, select the next row of the production records (a new crew) and proceed to do the same through all crews. If I could use an error on with nextrow, it would be fairly simple, but, Woe is me, that is not available. Any suggestions would be appreciated. Dennis Hodges Maintenance Management Manager FDOT Office of Maintenance MS #52 PH: (850) 410-5635 FAX: (850) 410-5511 [email protected] As far as we know, our computer has never had an undetected error. Please note: e-mail may be subject to public disclosure. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Thursday, August 21, 2014 10:50 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Overriding the default tab order on a form. At 10:36 AM 8/21/2014, Hodges, Dennis wrote: >Thanks Razzak. > >How can I determine if I am displaying the last variable in the table? >If last variable I want to set the focus to the first field in the next >section (another table), otherwise I want to move to the next record >and set focus to the first field in the current section. That is very easy to accomplish, Dennis! Let me send you an invitation with all details to show you how simple that task is ... www.join.me/RazzakMemon Very Best R:egards, Razzak >-----Original Message----- >From: [email protected] [mailto:[email protected]] On Behalf Of A. >Razzak Memon >Sent: Thursday, August 21, 2014 10:31 AM >To: RBASE-L Mailing List >Subject: [RBASE-L] - Re: Overriding the default tab order on a form. > >At 10:09 AM 8/21/2014, Hodges, Dennis wrote: > > >I have a form that edits multiple tables and want to override the > >default tab order if there are more records on the section I am > >currently editing. I can't seem to find a way to set the focus to a > >field in an EEP. Some sample code which does this would be greatly > >appreciated. > >Based on the user input, programmatically, you can switch between >fields and focus on any field, using the "SET_FOCUS" option of the >PROPERTY command as Custom Entry/Exit EEP. > >In order to accomplish such task, first you will need to assign unique >Component IDs for all relevant DB/VAR Edit controls. Then, use the >following sample code as an On Exit EEP. > >-- A very simple example >-- On Exit EEP > RECALC VARIABLES >IF vCheckValue IN (a,d,e,f) THEN > PROPERTY ComponentIDa SET_FOCUS 'TRUE' >ELSE > PROPERTY ComponentIDb SET_FOCUS 'TRUE' >ENDIF > RETURN > >Where: > >vCheckValue is the resulting value based on expression defined in a form. > >ComponentIDa and ComponentIDb are unique Component IDs assigned to a >given DB/VAR edit controls in form. > >Hope that helps! > >For more details and examples, refer to R:Docs 9.5. > >Very Best R:egards, > >Razzak. > >www.rbase.com >www.facebook.com/rbase >-- >31 years of continuous innovation! >16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! >--
