Card-Type Form - No Double Data

MaemiIshimura

Hi all,

I just start using NAV a week ago or so and I need your help with something.

In my form User Setup, there's a column to define which user is the one who will receive an email by default when someone sends an email in our costing form. In the User Setup form, the one by default is the one with the 'C' option set.

What I need to do is to make sure that there is only one person with 'C' and that if we want to change the one receiving the email by default, that the previous user won't have 'C' anymore. (C = option 1)

For exemple, if the User SPELLETIER is the one with 'C' but I want RLAURENCE to have the 'C', the 'C' for SPELLETIER must disappear and only be there for RLAURENCE once I make the change.

Thanks in advance for the help!

ara3n

If the field type is an option, you cannot change the value dynamically. If it's a lookup table, you can add code onlookup the filter it out.

I would just add code onvalide of the field to error out if the user selects it again.

Marije_Brummel

Move the setupfield from the user table to a normal setup table like inventory setup.

Someone choose the wrong pattern for the solution. If there is only one setup allowed it should not be in the user setup.

Standard NAV has an error like this to in the profile table. In here there is only one record allowed to be standard. It should have been in a setup table too.