| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Heelp need to walk through record
On Mon, 28 Oct 2002 21:50:14 GMT, Karsten Farrell
<kfarrell_at_medimpact.com> wrote:
>P B wrote:
>> I have a form which access a view. Record are access through a
>> composite primary key (file no and item name). I am able to move from
>> item to item using build-in like Next_Record, Previous_Record and
>> Go_Record which keep me into insert mode.
>>
>> The problem: the item are name. I would like to move from one record
>> to another without doing 200 times next record until I get the one
>> that I want. Go_Record is not usefull because I do not know the number
>> of the record associated to his name.
>>
>> I cannot also make a form (tab form) in which I list the record all in
>> one page since there is too many information to show.
>>
>> Since I might modify some item, I do not want to exit the inserting
>> mode and go into query mode to perform the search.
>>
>> How can I solve my problem
>If I understand your question, I think you need a "search" capability.
>Put a textbox on your form where the user can enter an item name. When
>they click the Search button, your trigger calls up the record(s) where
>item name is like whatever they type in the search textbox.
If I do that, I would have to leave the inserting mode and go into a query mode in which case, the form will ask me if I want to save any modification that I've done before which I don't want Received on Tue Oct 29 2002 - 07:33:29 CST
![]() |
![]() |