N
Ngan
I have SQL 2000 and Access 2002. I'm in the middle of
converting my access tables to SQL. Currently, in my SQL
server, I have tblClient (client home info) and
tblEligibility (their eligibility records, one-many
relationship).
Currently, in Access, I have a tblPerson that includes all
the tblClient fields and about 5 fields of
tblEligibility. I have a function that runs every night
to copy those fields from the two SQL tables into that one
access table.
In the near future, I want to have my access db to look
onto the SQL tables tblClient and tblEligibility
directly. I can do the link to the sql tables just fine.
My biggest problem is in the form displaying the
information of the client. It requires showing all of the
client info from the tblClient and the latest eligibility
record for that client from tblEligibility.
My first option would be: Have a qryMaxElig where it
finds the latest elig record for the client. My second
query would include qryMaxElig and tblClient.
In the Client Form, I can then display the info I want.
But on opening the form the first time, it takes about 30
seconds for the form to load because it has to run through
the query.
Is there an easier way of displaying the latest record of
another table in the Client Form that takes less time to
load?
converting my access tables to SQL. Currently, in my SQL
server, I have tblClient (client home info) and
tblEligibility (their eligibility records, one-many
relationship).
Currently, in Access, I have a tblPerson that includes all
the tblClient fields and about 5 fields of
tblEligibility. I have a function that runs every night
to copy those fields from the two SQL tables into that one
access table.
In the near future, I want to have my access db to look
onto the SQL tables tblClient and tblEligibility
directly. I can do the link to the sql tables just fine.
My biggest problem is in the form displaying the
information of the client. It requires showing all of the
client info from the tblClient and the latest eligibility
record for that client from tblEligibility.
My first option would be: Have a qryMaxElig where it
finds the latest elig record for the client. My second
query would include qryMaxElig and tblClient.
In the Client Form, I can then display the info I want.
But on opening the form the first time, it takes about 30
seconds for the form to load because it has to run through
the query.
Is there an easier way of displaying the latest record of
another table in the Client Form that takes less time to
load?