Single record tables

freddy.dk

Now it is my turn to ask a question to all the NAV experts here...

What is the preferred mechanism in NAV to limit a table to have only one record?

I can of course create a field, which always is 0 and set this to be the primary key - but is the best way?

bbrown

The standard NAV approach is to handle it in the form. You can see this in the various setup forms. There is nothing that prevents you from adding multiple records to a setup table via Object Designer. I think it's debateable whether this is the best approach.

Form - OnOpenForm()
RESET;
IF NOT GET THEN
  INSERT;

kriki

[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]

ara3n

I believe a new property in the Table called MaxNoOfRecord.

The default would be 0 = unlimited and users can set it to 1.



through code you could add OnInsert trigger.

If not ISEMPTY then
Error('You cannot insert more than 1 record into the table');