Yeah, I couldn't belive it.... Who the heck allows an autonum to start with 0! Not my database, so I'd have to ask the consultant I'm helping on this whether he would let me change it... I checked and ID 0 has data from 1997 to this month!
Karen -----Original Message----- From: Dan Goldberg <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, Sep 4, 2014 9:30 am Subject: [RBASE-L] - Re: Suggestions - "enter using" form 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
