Don't do an "append Blank", as explained below that sounds like the problem because you already have a blank in the Primary Key field in a another record.
Instead do an Insert into and populate at least the primary key field. However the question then becomes what is the Primary Key field and do you have enough information at that point to populate it with the proper value? Lou -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jean MAURICE Sent: Thursday, March 01, 2012 12:40 PM To: [email protected] Subject: Re: Cannot Insert Jerry pay attention to this point : if you have a primary key, you can do an INSERT BLANK but if you leave this record blank, you can't add another one because you can't have two 'blank' keys. HTH The Foxil [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/0bac2c1927422843b2c121c8b41684af148c1...@dfw1mbx24.mex07a.mlsrvr.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
