Require a Field

[js22]

Hello, I have a question that may not have an answer.

Is there a way to require a field? I have an inventory database that I'm setting up. One of the fields is entitle "Type". I'm wondering if there is a way to not allow you to move on to other sections of the database if the "Type" field is left empty for a new record entered?

Any advice would be great,

js22

[T-Square]

You can set a field to use validation, which will pop up a message when the validation fails. In define database, open the field's options and go to the tab for validation. You could use a calculation like: "Not(IsEmpty(ThisField))"

I have had trouble in FM7 with this method of validation under IWP. Basically, FM wants to put up a dialog box, but can't do that through the browser, and the system appears to hang. That may have been something with my own implementation, but I'd check that closely if I were deploying via IWP.

HTH,

David