dix
|
| Posted: 04/28/2002, 12:43 PM |
|
hello. i'm trying to work out a search function that pulls info from various tables on an ms access database. to make this work and retain reasonably good database structure, i've created a query that pulls the various fields from different tables. so far so good.
but how do i keep the results from repeating in the grid form for a single organization? since some of the organizations have a one-to-many relationship with some of the fields i'm searching on, i'm getting repeated info in my grid (i.e. organization shows up three times in the results for type because they have 3 target areas, another search paramete, but i want it to show only once...)
i'm sure i can't be the only person that's run into this. suggestions appreciated.
dix
|
|
|
 |
Nicole
|
| Posted: 04/29/2002, 6:26 AM |
|
Hello,
have you tried to use DISTINCT directive in custom sql?
|
|
|
|
dix
|
| Posted: 04/29/2002, 8:56 AM |
|
i haven't tried "distinct" in custom sql, no. i can understand most sql statements but i'm not much at writing them yet. i'll go search some info on distinct, though, and see if i can make it work. thanks for the suggestion!
|
|
|
|
Nicole
|
| Posted: 04/30/2002, 3:21 AM |
|
one more tip: create and test custom queries in db query analyzer before using it in project.
|
|
|
|
|
