Hello,
        I'm Using MSAccess as backend for my MySQL database. Tables are
linked with MyODBC 3.51, so all data user enters through MSAccess forms.
        I need that some fields (CustName) in MySQL table (CUSTOMERS)
would be required, it means, that user must fill a value into that field
(CustName) displayed on MSAccess form (Customers).

        MySQL table create statement is:
                create table CUSTOMERS (ID `ID` int(9) NOT NULL,
`CustName` Varchar(30) NOT NULL DEFAULT '');
        Default value in table declaration is requred as you know for
NOT NULL columns.

        The problem is:
                When user enters a new record in MSAccess form and does
not even touch field "CustName", new record is created with empty string
as default value!!!!
                If user enters for example "1" and then deletes the
value in MSAccess form, Access reports, that value must not be NULL. But
what can I do if user does not even go into that field and leave empty
field? User Must Enter A Value!!!! How to do this without writing many
code in every form with required (NOT NULL) fields?


        Thanks for any help, It is needed very very much because for now
any user can not fill required fields!
        It would be very very appreciated

Regards, Arunas


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to