When you add a new cust do you do it by import/gateway, calc the next number and add one using code, or using autonum by table control (autonum on this field) or by code?
Sincerely, Paul D. From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Wednesday, February 10, 2010 6:58 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Strange data? I just got a call from an office that updated to my last update in 7.5, I will update them to my app in 7.6 as soon as I get a few little things finished. So, they are still in the latest 7.5 compiled app, which is running great on lots of offices, but somehow they got a row of data in our daily file with custnum 0. They do not have a custnum 0 and I have a FK on that field. I tried to changing a valid custnum to 0 then save the row, I get the FK error as expected, I can not add a row to the table with custnum 0.... so how did that get in their table? This has happened them 2 times since they updated to my latest 7.5 app, a little egg on my face. I just do not know where to look for something like this, I may just add some code to find and delete things like this but I would really like to figure out how it happened. Thanks Marc
