Multiple child-record search form?

  • Thread starter ionic-fire via AccessMonster.com
  • Start date
I

ionic-fire via AccessMonster.com

I have an Access 2K3 MDB for which I have developed a search form modelled
after Allen Browne's sample search form.

One issue that I have found is that when there are multiple child records of
a parent record (related by PK-FK sets), the search results will show parent
records matched with child records. For example, I have one parent record
which has three child records associated with it by PK-FK relationship. In
the search form, it will display three records, with all data being the same
except where the child records differ.

This is an issue because when the user wants to view the data in a report,
each record wil show up as a unique record. I have gotten around this by
using two queries and the concatenate() function from Mr Duane Hookom. One
query is un-concatenated, i.e. has all child records displayed. The second
query has the multiple-record child fields concatenated with Concatenate().
This works, but results in a very very slow query results update/view.

I have been unable to come up with any other alternatives to this search
situation. Are there any out there?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top