Exhibit:
You are developing a form for customers to order tickets to events. There is an Event_Date item in the Ticket block of the form, and you want users to enter dates only for existing events. You use the LOV wizard to create an LOV based on a record group with the following query:
SELECT event_name, event_date FROM events
ORDER BY event_name
On the Column Properties page of the LOV (as shown in the exhibit), you click “Look up return item” and select the Tickers.Event_Date item from the items list.
You run the form to test it. However, when you invoke the LOV and choose an event, you receive the error FRM-40212: “Invalid value for field EVENT_DATE”.
What should you do to correct this problem?
A.
Change the Validate from List property for the Event_Date item to No-
B.
Create another item in the form to which the vent name can be returned.
C.
Modify the Record Group Query property for the record group to sort the list by event date.
D.
Modify the Column Mapping property of the LOV so that the event date, rather than the event name is returned.
E.
Modify the Record Group Query property for the record group so that the event date is the first column selected.