Mandatory Field

notblank - only works for keys.

The concept of Navision it's to validate fields during post. There are a few alternatives but don’t has the expected result.

bobnavision wrote:

set the field property notblank to yes

[-X I don't think it's gonna work...

Try to insert a new record, it will be properly stored without any value entered into this field.

Only in the case that field is in primary key, NotBlank property does what it should do.

I tried everything but didn't find proper solution to make foreign key which will accept only values from lookup table.

also search the forum for "mandatory fields" - many posts