Re: Saving from a form to table

--- Mike Richardson <mike-1gTsUfBLqWsG2Il/BtU0GPXRex20P6io@xxxxxxxxxxxxxxxx> 
wrote:

> On Thursday 29 Jul 2004 18:32, Darren wrote:
> > Thanks Mike, that worked to fix the error. 
> However it
> > did create another problem for me, which is that I
> > can't set the company number for a new contact,
> which
> > is required.  I expected that to happen when
> setting
> > the 'No Update' value, but it does still cause a
> > problem.
> >
> > Is there any way to work around it while still
> > updating the value to the database?
> 
> Is "companynumber" is the primary key, and is it an
> auto increment column?
> 
The 'CompanyNumber' field is an Integer type in the
Contacts table that this form is working with.  It is
linked to another table (Company) in which it is a
primary key/auto increment column.


                
_______________________________
Do you Yahoo!?
Express yourself with Y! Messenger! Free. Download now. 
http://messenger.yahoo.com