| LOV [message #81912] |
Tue, 01 April 2003 04:18  |
merry
Messages: 5
Registered: November 2002
|
Junior Member |
|
|
HELLO,
I HAVE CREATED A LOV AND ATTACHED THE SAME TO THE THE TEXT ITEM.WHEN I ENTER VALID ENTRY FOR THE DATA IN THE LOV, LOV IS COMING .BUT IF I ENTERS AN ENTRY WHICH IS NOT IN LOV, I SHOULD DISPLAY AN ALERT TELLING THAT THE RECORD FOR THIS ENTRY IS NOT PRESENT . CAN ANYONE HELP ME?
Thanks
Merry
|
|
|
|
| Re: LOV [message #81913 is a reply to message #81912] |
Tue, 01 April 2003 05:13  |
utsav
Messages: 94
Registered: March 2003
|
Member |
|
|
Hi,
Well since u have a lov attached to text item, set the validate from LOV property to true of text item.
In this way u will be able to know if the value being entered is from LOV or not.
utsav.
|
|
|
|
| Re: LOV [message #81923 is a reply to message #81912] |
Wed, 02 April 2003 01:19 |
merry
Messages: 5
Registered: November 2002
|
Junior Member |
|
|
Hi,
I think I have to be more specific with my problem.
I have 3 tables , say cargo, pax and secure. I have a query form which contains airwaybillno,manifestno,date,comingfrom,flightno columns.
If the user select airwaybillno or manifestno, the record will be displayed and it is working perfectly fine, since both of these fields are unique.
But when the user enters a particular date say 23-mar-03 then if the details for that date only should appear as an lov. If the data is not there in Lov for that particualr date, then an error should display. How to do this?
thanks
merry
|
|
|
|
| Re: LOV [message #81933 is a reply to message #81923] |
Wed, 02 April 2003 15:08 |
Julie
Messages: 98
Registered: February 2002
|
Member |
|
|
|
Maybe you need to base your LOV record group on a union query, with select statements and where clauses to address each case.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
