PC Review

Thread Tools Rate Thread

searching records which have multiple related records

Posts: n/a
      16th Jan 2008
Greetings and salutations. I have developed an A2K3 MDB and have a search
form modeled after Allen Browne's search form (
http://allenbrowne.com/ser-62.html). It works well except for records which
have multiple related records in 1:many relationships and many:to:many
relationships. To view my results, I created a query called qryAllData which
contains all of the data from several tables for each record.

For example, say I have one record in the main table, and six related
records; the search form (which is bound to qryAllData) will display six
records. All records are duplicates of each other, except for the one field
which will have a different value for each of the six related records.

What I have envisioned is to have the search results return one line per
unique primary key that matches my search criteria, and if there are any
related records, to have a little plus-sign that the user could click to view
the related records if need be.

I have an access report which will display all the results in proper format
(i.e. no duplicates, etc.). I would also like to export data to excel without
all the duplicated data.

What I am seeking is some input as to how I might accomplish this task. Or,
perhaps, is access/JET even the correct program/engine to be using? Is SQL
server or Oracle a better engine instead of JET for this particular task?

Message posted via http://www.accessmonster.com

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo box for related records AND non-related records rocketD Microsoft Access 3 16th Nov 2009 07:34 PM
Related records depend on other related records BruceM Microsoft Access Database Table Design 2 31st Oct 2008 12:46 PM
searching records which have multiple related records Broomsticks Microsoft Access Form Coding 0 15th Jan 2008 11:08 PM
Looking up a related record in a related form =?Utf-8?B?SmltIE5vcm1pbGU=?= Microsoft Access Forms 0 3rd Nov 2004 04:46 PM
Searching for child records in related tables in ADO.net Gordon Microsoft ADO .NET 0 20th Oct 2003 11:44 PM




All times are GMT +1. The time now is 11:16 AM.