2 fields on an Index statement???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Mucho gracias, Senor!

Rick B said:
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
Click to expand...
 
recTemp.Index = "Unit" & "ResidentName"
recTemp.Seek "=", AptUnit, ResName
Click to expand...

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


Hope that helps?


Tim F
 
Back
Top