Indexing questions

[Evelyn]

I am a newbie and having a very frustrating problem. I
have three tables:
- client table (file# is primary key)
- registrations (reg# is primary key)
- Daily Appointments (logid is primary key--autonumber)

I have all three of these linked together in a query to
give me the following form:
names of active clients (combining various fields from
client and registration table)...works great. And then
pulls the last date of contact from the daily appointments
table.

The problem that I am having is that I pull up the last
appointment and some of them are incorrect. It looks like
the daily appointments table is using the order of the
logid NOT the date in ascending order using the last
feature. Is this because the logid is indexed? Can
someone PLEASE teach me a way around this.

Thanks so much!

 

[John Vinson]

The problem that I am having is that I pull up the last
appointment and some of them are incorrect. It looks like
the daily appointments table is using the order of the
logid NOT the date in ascending order using the last
feature. Is this because the logid is indexed? Can
someone PLEASE teach me a way around this.

A Table is an unordered "bag" of data. It will (usually) be displayed
in the order of its Primary Key, but you can't count even on that on a
subform.

Base your "last appointment" on a Query using a sort order on the date
rather than assuming that the table is in any particular order.