Validation rules, default values, input masks & sort orders - in the form or in the table?

[GopherUK]

Hi folks,

Just wondering how the professional developers choose to do this? Should these be in the placed in the tables or in the forms? It would seem to be that tables should simply be properly constructed with the field types and relations and all of the above along with the lookups should be done in the form itself? Is that correct?

Thanks in advance,

Gopher.

 

[xenou]

Great. You also probably want to make sure you set the combo box property "Limit to List" (Yes). Otherwise user's can still enter free form text input ... !

ξ

 

[Justinidea]

yup, did that. Thanks