Hi,
I'd like to use the add multiple feature in dbman sql 2 to give users the option of adding several records using one form. So I have this:
db.cgi?do=add_multi_form&m=5&db=Company_Product
The problem I have is that if the user decides to add two records, and leaves the remaining records blank, I get a load of error messages like this:
# Column Product Code cannot be left blank.
# Column Category Code cannot be left blank
Is there any way I can tell dbman sql to ignore blank records when adding, so the user gets an add success message for the records he has added?
thanks
Tim Ault
Oxford UK
I'd like to use the add multiple feature in dbman sql 2 to give users the option of adding several records using one form. So I have this:
db.cgi?do=add_multi_form&m=5&db=Company_Product
The problem I have is that if the user decides to add two records, and leaves the remaining records blank, I get a load of error messages like this:
# Column Product Code cannot be left blank.
# Column Category Code cannot be left blank
Is there any way I can tell dbman sql to ignore blank records when adding, so the user gets an add success message for the records he has added?
thanks
Tim Ault
Oxford UK