Query Fields by Page??

I have normalized my data as much as possible but have found the need to use multiple pages for a particular project (actually several projects). The database is used to store information on terminal ids, Customer name, room, building, device type, TCP/IP#, Token Ring Numbers, IDF, MDF, etc...

Anyway...bottom line: TO_MANY_FIELDS_NOT_ENOUGH_REAL ESTATE

Everything was fine until today when they want to add 6-7 additional fields to the table and it doesn't make sense to have seperate tables or seperate FoRMs to query data.

I have written some procs to help customers query items on page #2 via a pop-up window but cursor navigation for more than two pages ... well ... I don't want to think about it!

QUESTION:

• Has anyone written or knows of a way to use the enter_query key to prompt the customer for the data_area they are interested in?

Like I said...I've solved the page 1 & 2 issues but would like to know if there are solutions to page nn queries.

Oracle's enter_query likes field/column #1 ... forcing it to another page and being able to view other data while keeping the cursor on the queried page is the trick!

Further example: Some terminals have cable#'s, but not TCP/IP or Token Ring addresses, yet others my only be LAN workstations and still others may have Token Ring Addresses and TCP/IP#'s or one or the other. But all devices/terminals/workstations will have Telecommunications info ... patch panel info ... MDF or IDF or XDF stuff ... serial numbers ... etc...

Let me know if you have any ideas or further questions...thanks.

Mike Oswald                        _               o
Univ. Of NE Medical Center       ___\o_    __o    <|\
Computing Services/Telecomm      ~~~~~~  _ \<_     \
600 S. 42nd ST.                         (_)/(_)    /