I thought the same thing, but there is a "save row" eep already on the first
table, and the row does save (I see it in another open session) and the save
eep evaluates, so the row is there and the BrokNo is valid at that moment
because I created a watch variable to see it and it's good. But as soon as the
cursor lands on the 2nd table, that variable I have assigned to the BrokNo as a
test immediately changes back to a 0.
I even went so far as to locate a field for BrokNo on the 2nd table in the
scrolling region. I created a
vKeepBrokNo = .vBrokNo
on exit of the first table and on entry into the 2nd table I do a
property brokno textvalue .vkeepbrokno
It works at the moment, I see the value in there, but as soon as I try to save
the row, I see the BrokNo field change to a 0 in front of my eyes and I can't
save because of the FK on that field to the PK of the 1st table.
Karen
-----Original Message-----
From: Albert Berry <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Thu, Feb 5, 2015 4:25 pm
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
