[AccessD] (no subject)

So do you have forms that match all the various table data structures to
use in displaying that record?  Or do you have multiple tables that are
all the same structure with merely different data in them (NAUGHTY!!)?
Actually even if you have different data structures, you should have a
single "people" table that contains the part of the data structure that
will be consistent for all different types of people in your database.
If you have special data to capture about a particular kind of "people"
that can be captured in a separate table.  That would simplifiy your
life a lot when it came to finding someone, since regardless of their
category, the basic information would all be in one table.

Charlotte Foust


-----Original Message-----
From: Klos, Susan [mailto:Susan.Klos at fldoe.org] 
Sent: Friday, August 19, 2005 10:24 AM
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