You can probably use bookmarks if you have the same primary key columns in
the query and the table.
We need more details to know that however.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "bmckenna6" <bmckenna@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, August 20, 2002 7:09 PM
Subject: [IBO] How do I (find or locate) a record in an IBOQuery


> w/ IBO4.2 and D3.02:
>
> My Db skills have not been highly developed
> yet, so please bear with me here if this
> is, indeed, some simpleton question.
>
> I have an IBOTable and an IBOQuery.
>
> An IBOQuery result set is initially returned
> from the IBOTable's table.
>
> I browse, in different grids, back and forth
> from that same IBOQuery/result set to the IBOTable.
>
> It is no problem to go from the IBOQuery to the
> exact record in the IBOTable, using 'Locate.'
>
> But I also need to go from the IBOTable back to
> the same record in the IBOQuery (or since the
> record I'm on in the IBOTable is likely not returned
> in the IBOQuery - to the Nearest...).
>
> What is the simplest approach to employ for
> this task, please?
>
>
> I've tried using SetKey and GoToNearest,
> but I get the error 'Field is not indexed
> and cannot be modified.'
>
> Could this work if I had generated an index
> for the IBOQuery/result set, or what...
>
> If so, how do I generate an index for the
> IBOQuery/result set?