By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,639 Members | 1,988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,639 IT Pros & Developers. It's quick & easy.

searching records with multiple related records

P: n/a
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?
Jan 15 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.