|
| Unique key in NAV |
 |
Thu, 27 Mar 2008 18:22:00 -070 |
Hi all,
How can I set a unique key in a table from NAV? I can set 1 clustered index
and a number of non-clustered index. But I can't find where I can set a field
as UNIQUE...
Many thanks,
Damon
|
| Post Reply
|
| Re: Unique key in NAV |
 |
Fri, 28 Mar 2008 00:53:52 -070 |
Hi Damon,
in NAV you can't set unique key. You can do unique field only in
triggers.
Regards
|
| Post Reply
|
| RE: Unique key in NAV |
 |
Fri, 28 Mar 2008 04:36:01 -070 |
Dear Damon
You can setup the unique key (= Primary Key in NAV, not SQL) in first line
on the Keys list (design your table, then View, -> Keys) in the NAV
environment.
P.S. The SQL-version is more complicated. If you need more information, send
letter.
"Damon" wrote:
> Hi all,
>
> How can I set a unique key in a table from NAV? I can set 1 clustered index
> and a number of non-clustered index. But I can't find where I can set a
field
> as UNIQUE...
>
> Many thanks,
> Damon
|
| Post Reply
|
| Re: Unique key in NAV |
 |
Sat, 29 Mar 2008 20:03:02 -040 |
Unfortunately the NAV table designer does not have a property for that, and
I would try to avoid setting it on SQL Server to enforce it, because in that
case you would get SQL Server errors along with regular NAV errors, and that
doesn't help with consistency in the application. You will have to program
field validation to enforce field uniqueness.
--
Daniel Rimmelzwaan
MVP Dynamics NAV
www.risplus.com
"Damon" <Damon@discussions.microsoft.com> wrote in message
news:71720DA3-2954-4C41-93E5-C4BF086570DD@microsoft.com...
> Hi all,
>
> How can I set a unique key in a table from NAV? I can set 1 clustered
> index
> and a number of non-clustered index. But I can't find where I can set a
> field
> as UNIQUE...
>
> Many thanks,
> Damon
>
|
| Post Reply
|
|
|
|
|
|
|
|
|
|