Home » Developer & Programmer » Forms » Mandatory Field problem
Mandatory Field problem [message #392209] Tue, 17 March 2009 01:00 Go to next message
Messages: 36
Registered: October 2006
i have a composite primary key of which Date is one component.
In the form,i'm displaying 2 columns - the date as well as the amount in a multi-record block.
I enter the date and the amount for the 1st record,dont save it and proceed to the next record.Here again I enter only the date but then decide to wipe off the date and try to save the 1st entered record.It gives me an error "This field must be entered"..I guess this might be due to the date being a part of the primary key and it is displaying its default behaviour.

any thoughts on how to handle this?

Re: Mandatory Field problem [message #392220 is a reply to message #392209] Tue, 17 March 2009 01:30 Go to previous messageGo to next message
Messages: 21127
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Don't "wipe off the date", but remove (delete) the whole record.
icon12.gif  Re: Mandatory Field problem [message #392233 is a reply to message #392209] Tue, 17 March 2009 02:10 Go to previous message
Messages: 551
Registered: August 2005
Senior Member
Dear Friend,

When you declare a column as a Primary Key (Pk) that means it will be Unique and Not Null.

So you have created a composite PK so you can't just give one value and not the other one. You have to give both value because its a composite Pk.

Azam Khan
Previous Topic: Summary Field Validation!
Next Topic: database not updating
Goto Forum:

Current Time: Sat Jul 22 14:10:09 CDT 2017

Total time taken to generate the page: 0.12733 seconds