to view record once that has one to many relationship

[geetharej]

There are 2 tables. one to many relationship. i need to retrive data from both tables with a join query. when i run the query records are getting repeatedly shown.
how do I get a single row out of it ?

thanks

 

[neileg]

Do you want just one record from the many side, or do you want them all?

If you want just one, use an aggregate function like First or Max or whatever in a query.

If you want them all, it's very difficult to do this in a query. Easy in a form or report providing you are happy that the many side records are listed, but not in a query.