I would bite the bullet and change the ID of the 0 supplier everywhere in the
database, make sure they cannot use 0 in the future, and be done with it. That
sounds like less headaches.
I always start ID autonumbering with 1. Good to know not to use 0!
Dan Goldberg
From: Karen Tellef
Sent: Thursday, September 04, 2014 7:22 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
