please help me on this issue. This is my form layout...
COUNTRY REG.NUM START_DATE END_DATE
US R1111 3-Mar-2009 10-Apr-2009
CAN P4444 5-Apr-06
Today is 06-Apr-2009 and the first record will end_date on 10th april.
The third record is creating by user for same country with different reg.number. and my question is the start_date will not allow less than first record end_date.
That means third record start_date should be greater than
what to write the code and where to write.(In when validate item or when new record instance and what to write because it has to check previous record)
Please help me out.
Thanks in Advance
[EDITED by DJM: applied [code] tags to sample data]
[Updated on: Tue, 07 April 2009 19:27] by Moderator
Report message to a moderator