470,620 Members | 1,413 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,620 developers. It's quick & easy.

searching records with multiple related records

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
0 1462

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Robert Oschler | last post: by
3 posts views Thread by Simone | last post: by
reply views Thread by qudra | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.