Is it possible to use 2 indices on a single seek? My table has the following
indices: Unit and Name. The table logic is that a single unit may have up
to 11 different names associated with it. Therefore, to get a unique read,
the two keys need to be "joined" in the seek statement. Here's what I have
got so far:

recTemp.Index = "Unit" & "ResidentName"
recTemp.Seek "=", AptUnit, ResName

The problem here is that the index combines the two names and, of course,
cannot find the "UnitResidentName" column. I've tried using a comma, but to
no avail.

Are there any options other than creating a primary key field that combines
these two values?

Rick Brandt (that is not me) just answered this same question in the QUERIES
newsgroup a few hours ago. The subject is "Creating an Index on Two
Fields".

Rick B



"roy_ware" <(E-Mail Removed)> wrote in message
news80BE4E8-FB80-46F2-91E2-(E-Mail Removed)...
> Is it possible to use 2 indices on a single seek? My table has the
following
> indices: Unit and Name. The table logic is that a single unit may have
up
> to 11 different names associated with it. Therefore, to get a unique
read,
> the two keys need to be "joined" in the seek statement. Here's what I
have
> got so far:
>
> recTemp.Index = "Unit" & "ResidentName"
> recTemp.Seek "=", AptUnit, ResName
>
> The problem here is that the index combines the two names and, of course,
> cannot find the "UnitResidentName" column. I've tried using a comma, but
to
> no avail.
>
> Are there any options other than creating a primary key field that
combines
> these two values?

Mucho gracias, Senor!

"Rick B" wrote:

> Rick Brandt (that is not me) just answered this same question in the QUERIES
> newsgroup a few hours ago. The subject is "Creating an Index on Two
> Fields".
>
> Rick B
>
>
>
> "roy_ware" <(E-Mail Removed)> wrote in message
> news80BE4E8-FB80-46F2-91E2-(E-Mail Removed)...
> > Is it possible to use 2 indices on a single seek? My table has the
> following
> > indices: Unit and Name. The table logic is that a single unit may have
> up
> > to 11 different names associated with it. Therefore, to get a unique
> read,
> > the two keys need to be "joined" in the seek statement. Here's what I
> have
> > got so far:
> >
> > recTemp.Index = "Unit" & "ResidentName"
> > recTemp.Seek "=", AptUnit, ResName
> >
> > The problem here is that the index combines the two names and, of course,
> > cannot find the "UnitResidentName" column. I've tried using a comma, but
> to
> > no avail.
> >
> > Are there any options other than creating a primary key field that
> combines
> > these two values?
>
>
>

"=?Utf-8?B?cm95X3dhcmU=?=" <(E-Mail Removed)> wrote in
news80BE4E8-FB80-46F2-91E2-(E-Mail Removed):

>
> recTemp.Index = "Unit" & "ResidentName"
> recTemp.Seek "=", AptUnit, ResName
>

PARAMETERS AptUnit TEXT, ResName TEXT;
SELECT * FROM MyTable
WHERE Unit=[AptUnit] AND ResidentName = [ResName];


Hope that helps?


Tim F