navigate to record based on Select Field

Applications Forms
#1

I hope you will excuse the simplicity of my question, I am coming from an Access and ASP world…
I am trying to navigate to a particular record when I update my select field (that is not the primary key)

Let me tell you what my form looks like:

Fields:
ID (Primary Key)
Client (select text field)
Detail1 (text)
details2 (text)

Here is the sql code for my select box:
SELECT ID, Client
FROM TABLE
ORDER BY Client

I also have the checkbox enabled to reload form when value has changed.

When I select the Client name, I want my form to navigate to that client’s record, but clearly I am missing something (an event) that executes after I select my client.

I have tried to use the ID field for the Select field, but for some reason (probably due to the PK) the field always looks disabled.

Thanks very much.
STeve

#2

Re: navigate to record based on Select Field

I’m not sure if I follow your question, but you can create field events onchange with ajax menu item and javascript action. But the problem is that you want to scroll the SQL cursor within the resultset of a query. That’s not possible in a SQL resultset in general. If you want to navigate to a certain (set of) record(s) you need to retrigger some sql:

SELECT ID, Client
FROM TABLE
where Client=‘global/field variable’;
ORDER BY Client

#3

Re: navigate to record based on Select Field

Thanks very much. I’ll give that a try.
I guess that is one place where Access made things simple.