Customised search and displaying results

This is one of the requirements of a corporate phonebook search I am currently working on:

"If the search does not return enough records to fill the user’s display and the search has used last name as the search criteria, enough closely matching records to fill the screen will also be displayed, sorted by last name (half above the hits, half below). Records that matched the search criteria exactly will be prominently highlighted."

What it means:
Let's assume that "fill the screen" can be any reasonable, hard coded number of records.

Searching for last_name = 'Smith'

They want to see search results on the screen in something-like-this fashion:

Smithers
Smithe

Smith  --highlighted
Smith  --highlighted
Smith  --highlighted
Smith  --highlighted
Smith  --highlighted

Is this doable with Oracle Forms 6i: positioning matching records on the screen, displaying "closely matching" results "half above the hits, half below", etc.
The client wants speed : there will be only one table with ~5000 records to search and required response time is 0.5s. I am afraid that this requirement can compromised it.

Could anyone help, please.

Thank you

Roman Received on Mon Nov 12 2001 - 16:03:08 CET