Yeah, I might have to go that route. Problem is that both tables have alot of "not null" columns so that's not easy. I think I might design a form to gather the data just for the 1st table, then do an "edit using" and let them go to the 2nd tab and use the navigator bar to enter rows that way. The only thing I lose is that they can't just hit [enter] after each row in the region to start another row.
Karen -----Original Message----- From: Bill Eyring <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, Feb 5, 2015 4:58 pm Subject: [RBASE-L] - Re: Enter Using with 2-table tab form Karen Have you tried adding a row to the 2 tables with a unique new id and then use 'Edit Using' ? Bill Eyring From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: Thursday, February 05, 2015 5:25 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Enter Using with 2-table tab form I think you might need to refresh table 1 on exit so table 2 can see it. Albert On 2/5/2015 3:07 PM, Karen Tellef wrote: Losing my mind here, I must be missing something simple. I have a 2-table form, with 2 tabs. When I do an "edit using", I'm able to go to the 2nd table/tab (which is a many-row) and using the navigation bar I can add a row and it saves just fine. There is one common column called BrokNo and it automatically brings it in. The issue is that I want to do a "enter using" like the form did in DOS. However, when they're done with the 1st page and click on the 2nd page, I can see behind the scenes that the internal BrokNo changes to a 0 once I click into that second page (using trace and watch variables). I've tried setting variables all over the place and it still tries to save that 2nd page with a BrokNo of 0. Is there something special I need to do? Hard to believe I haven't tried this before.... Of course, I generally hate using "enter using" but thought I'd try it for simplicity. Karen -- A democracy ..." can only exist until the majority discovers it can vote itself largess out of the public treasury." Attributed to Alexander Fraser Tytler 1747-1813
