How do you move / goto record using php?

Applications Forms
#1

Normally, when I open a form, it will display the first record as defined by SQL.

How do I move to certain record using PHP / javascript? For example, the form contain customer number 10000 to 90000. When I first open it, it shows record for customer number 10000. If I want to goto customer number 50000, how do I do it using php code (NOT Quick search).

Thanks.

#2

[QUOTE=capecode;24975]Normally, when I open a form, it will display the first record as defined by SQL.

How do I move to certain record using PHP / javascript? For example, the form contain customer number 10000 to 90000. When I first open it, it shows record for customer number 10000. If I want to goto customer number 50000, how do I do it using php code (NOT Quick search).

Thanks.[/QUOTE]

That won’t be easy. Of course you can if you are in full control, i.e. within events, but the only thing I can think of is by modifying the SQL. But then you are influencing the resultset which isn’t what you want I think. You might find an opening if you dive a bit in the generated code and look how the ‘goto’ works.

#3

Thanks aducom,

You are right, modifying SQL will not work the way I want it. I guess I have to find other ways.