Hide Dups in Query or AllowUpdates in Report.

[dschomburg]

Mondays - ya know I love em.

My query returns data like;
Name: Adres: Item: IsShipped(checkbox)
Cindy Loo Who 12345 Elm St Thing#1
Cindy Loo Who 12345 Wlm St Thing#2 (checked)

The info is comming from 3 different tables and I need to update the data. Like checking off, when an item is shipped.
I would prefer to do this on a form but how would I only show 1 instance of Name, Adres. And each individual Item and IsShipped? - I can do this on a report but can not update it (duh) - I can update from a query or a form but can not surpress duplicates.

Any help would help a heap.
Thanks,
Dave

 

[THoey]

I am not good with them, but this sounds like a great place for a form with the name and address on it and then a subform with all the items and whether or not they have been shipped. I am not sure if you have experience with them, but if not, I know there are a bunch here that do. They can help you out... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[dschomburg]

Oh yeah, Sub-Forms! I always forget about SubForms and SubReports. I will try this out. Thanks.