Subject Re: [IBO] Locate problems
Author lester@lsces.co.uk
> In fact on the query I just want to return a record to be edited but I have
> to be able to searche it in two ways: human readable way (two fiels both
> indexed) and id (LongInt identifier).

I presume that the id is unique?

This is exactly what I do. The main query has a parameter of
the 'unique id', and a couple of other queries with the
relevent parameters return the id for the main query. If
more than one record is returned on the sub-search, then
something has gone wrong, and the client can 'correct the
fault' <g> - does not happen very often, but the mainframe
system that feeds data has a flaw <bg>

My local copy of the data is scrolled in a grid, and the id
used to access the master database if required. Most of the
time the data in the local copy is all that is needed.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services