[AccessD] (no subject)

If the contact tables have the same structure why not create a union query
and in the criteria put the key of the record you are looking for so the
result set would have the record(s) you want.
Jim Hale
-----Original Message-----
From: Klos, Susan [mailto:Susan.Klos at fldoe.org]
Sent: Friday, August 19, 2005 12:24 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] (no subject)


Once I have found the record in the table I want to open a form that
shows me that record.  Let me go back to my original problem.  I have
several tables of contacts.  I have a form with a tabbed subform.  Once
I have used my find form to search my various contacts tables and found
the contact, I want the first tab to show me all the data about the
contact, then I want the second tab to show me the data from the phone
conversations I have had with that contact.  These are linked through a
linking table by contactID.  If the person I am trying to find is not in
one of those contact tables, then I want the form to open up blank so I
can type in the information which would be loaded into a different
'people' table.  If anyone can help me on this, I would be very
grateful.  Thank.s

 

Date: Fri, 19 Aug 2005 08:47:45 -0700

From: "Charlotte Foust" <cfoust at infostatsystems.com>

Subject: RE: [AccessD] "Find" combo box searches more than one table

To: "Access Developers discussion and problem solving"

      <accessd at databaseadvisors.com>

Message-ID:

 
<E61FC1D4B1918244905B113C680BEA86873BD8 at infoserver01.infostat.local>

Content-Type: text/plain;     charset="us-ascii"

 

I never understood what the user expected to "find" in such a search
function.  Did they want to know every table the value appeared in, did
they want to magically "see" each record in some form?  Are they
expected a treeview showing all the hits in each record in each table?
It isn't hard to find a value by walking the tables, but what did you
want to do with the results?

 

Charlotte Foust

 

 

Susan Klos

Senior Database Analyst

Evaluation and Reporting

Florida Department of Education

850-245-0708 

sc 205-0708

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.