mibuso.com

Microsoft Business Solutions online community
It is currently Wed Aug 27, 2014 6:58 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: Eliminate null entry on table
PostPosted: Sat Apr 28, 2012 6:12 pm 
Offline

Joined: Thu Dec 16, 2010 8:11 am
Posts: 97
Country: Bangladesh (bd)
Hi all,

I have designed a table which is populating my records correctly.

But on the last line, I have a null entry. Is it because of 2 fields I have created, one as Integer and the other as Option.

How to eliminate this null-entry line?

Thanks
Liizz


Top
 Profile E-mail  
 
 Post subject: Re: Eliminate null entry on table
PostPosted: Sun Apr 29, 2012 10:39 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4592
Location: Hyderabad
Country: India (in)
What is the Primary Key of the table?
Set Not Blank property of all fields included in Primary Key to Yes..

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: Eliminate null entry on table
PostPosted: Sun Apr 29, 2012 5:41 pm 
Offline

Joined: Thu Dec 16, 2010 8:11 am
Posts: 97
Country: Bangladesh (bd)
Primary Key:Document No.

But on the manual it is mentioned that this property NotBlank should be Yes to only the primary key.

Thanks

Liizz


Top
 Profile E-mail  
 
 Post subject: Re: Eliminate null entry on table
PostPosted: Sun Apr 29, 2012 9:34 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jan 02, 2003 6:37 pm
Posts: 7990
Location: Howell, MI
Country: United States (us)
Yeah that's what Faithie said too
http://dynamicsuser.net/forums/t/51849.aspx

_________________
Daniel Rimmelzwaan
MVP - Dynamics NAV


Top
 Profile  
 
 Post subject: Re: Eliminate null entry on table
PostPosted: Mon Apr 30, 2012 7:53 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4592
Location: Hyderabad
Country: India (in)
mohana_cse06 wrote:
all fields included in Primary Key

That is what I said too..

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 13 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: