Multiple choice

Tom is developing a form for customers to order tickets to events. There is an Event_Date item in the Ticket block of the form, and he wants users to enter dates only for existing events. He used 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_nameOn the Column Properties page of the LOV (as shown in the exhibit), he clicked Look up return item and select the Tickets. Event_Date item from the items list. He runs the form to test it. However, when he invoked the LOV and chose an event, he received the error FRM-40212:

Invalid value for field EVENT_DATE.'

What should he do to correct this problem?

  1. Change the Validate from List property for the Event_Date item to No

  2. Create another item in the form to which the event name can be returned

  3. Modify the Record Group Query property for the record group to sort the list by event date

  4. Modify the Column Mapping property of the LOV so that the Event Date, rather than the Event Name is returned

  5. Modify the Record Group Query property for the record group so that the event date is the first column selected
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The error occurs because the LOV is returning the wrong column. The record group query selects event_name first and event_date second, but the Column Mapping is configured to return from the first column (event_name) to the Event_Date item. The solution is to modify the Column Mapping property so that the second column (event_date) is returned instead. Changing the query order or creating another item would not solve the fundamental mapping issue.

Keep practicing — related questions