Select row info of a report from a text field.

On this forum, you show up as user8612216. That's an anonymous account. You need to create an account for the forums themselves...this is distinct from your support account.

So, really, the report is just a visual so that the users know know what they are pulling up. Got it.

Based on your response, I think this is the basic, desired processing flow:

1. Report is displayed with row numbers.
2. User enters a row number and hits enter.
3. Get PK value(s) *.
4. Use PK value(s) to invoke some back end processing for the desired row.

* Get PK value(s)...If you are able to link the number entered by the user to the primary key value(s), this is much simpler. You might consider either:

1. Have them enter a PK value rather than a row number
2. Prepare a determinate query that will always produce the same row number mapped to the same PK.

If neither of these can be done, there are options but, it gets a lot more complicated.

1. Write a PL/SQL process on submit that does what you need and uses the value held in your page item to determine which item is affected; either by direct PK value (Option 1) or by executing a query to find the PK value(s) (Option 2).
2. Enable the Submit when Enter Pressed property  on the page item control.

Then, when the user types in a value and hits enter, your PL/SQL process will fire.

-Joe

@Ken S.

Mind marking my answer as correct then?

Thanks,

-Joe