Karen,
This is one of the reason I hardly ever use forms in the ENTER mode. I
normally prompt the user for the basic information and then create a new
record with basic information that they can edit.
In your particular case, can you make the default something other than NULL,
say 9999 that has an associated name and address defined as "Undefined -
Please update supplier ID" or something along these lines, and when they
change the ID it updates to the correct information? I believe there is a
place in the form where you can change the default value when used in the
ENTER mode; I used to do this all the time in the older versions but since I
no longer use this approach I am not sure it is available, but I would
think/hope it is still available.
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef
Sent: Thursday, September 04, 2014 9:23 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Suggestions - "enter using" form
I want to use the same form for both editing and entering. The database has
ZERO ON and I'd like to keep it that way because there's lots of calcs on
the form that need to operate with null values.
There is a "supplier" field (column ID), and the customer and address info
are displayed on the form using form expressions. The problem is that there
is an actual supplier with an ID of 0 !!! So when the form comes up
("enter using master") it displays info for ID = 0 on the form until they go
in it and change the supplier. I can null out those values in a "form on
after start eep" but as soon as they cursor thru preceding fields it
immediately fills back in. OTOH I have to make sure they can actually
display info if they choose ID 0, so I cannot change my form expressions to
ignore ID 0.
I'm thinking I'd have to remove those form expressions and instead use EEPs?
On after start capturing whether it's "edit using" and then populating the
fields, and then an EEP on exiting the supplier field to display again?
Anyone think of anything else I can do? Thanks!
Karen
