Search question

[Ron Weaver]

I have a database setup simular to Northwind, with a 'Product' table. I also
have 'Food and Beverage', and 'RoomSetups' tables, which are many to many
tables just like the Products table in Northwind. This database is used for
booking meetings at a hospital. The 'Orders' form has three subforms: One for
booking the equipment item(s) needed, one for ordering food and beverages,
and one for room setup combinations. I need to create a search for each of
these catagories, i.e.; a list of orders including Food and Beverages. I have
been able to accomplish this in a report, but when I use a list box, one
order is listed multiple times when multiple food and beverages are ordered.
Is it possible to get this to show as one order.
I really hope this makes sense to somebody. Thanks for any help.
Ron

 

[B F Cole]

Ron,

If you are populating the list box with a query, try setting the "Unique"
property to Yes in the query general properties.

Bill

 

[Ron Weaver]

Hi Bill

There is a "Unique Values" and a "Unique Records" property. I tried them
both, (you can select one or the other for "Yes"). Neither worked.
Thanks for your response.
Ron

 

[Ron Weaver]

Bill,
I removed the tables from the query, then replaced them along the fields. It
works now?? The "Unique Records" did the trick.
Thank you very much!
Ron