adding default value and toggling fields to accept data dependant on another fields data

generated dataassist database file would like to add 777 as the default value to height and width fields
nb database inserts 777 but thee form puts in 0 ts why i am looking at setting default ???


aslo what i would like to do if possible is if AREAID is <> FREE then SCREENID = FREE and visa versa on INSERT and UPDATE pages

It looks like the height and width columns are being set from fields in the form. You have lists for both AreaID and ScreenID fields. Are you saying one of the two always has to be "Free"? How many other options are there in the lists?

height and width in the form are override to the default values set in database, when add record with these empty in the form,0 is put into database not the default value.

the list could have 30 entries in each i know the value of FREE in both case so was hoping to put these into approiate fields

You can put the default value in with the binding for the field.

Right now for instance the width is set to: <?php echo((isset($_POST["TestimonialImgWidth"]))?$_POST["TestimonialImgWidth"]:""); ?>

Instead set it to: <?php echo((isset($_POST["TestimonialImgWidth"]) && $_POST["TestimonialImgWidth"] != "")?$_POST["TestimonialImgWidth"]:"777"); ?>

Then it will set the value to 777 when it is left blank.

I still don't quite understand the FREE scenario. You have fields to set those values. When would they be used? When would they be ignored and use the FREE value?

FREE has a value of 999 so what am trying achieve is that only 1 of rge fieds can contain999

cannot find the statement you indicated

Double click on the insert record server behavior to open it and then go to the bindings tab and click on the Width column. That is where you would make the change.

What would the result be if they tried to insert FREE for both? No insert takes place and you display an error message?

someone pointe out an easier solution and it woks, thanks for help