Re: use a list with checkboxes to select categories
From: JimBartlett (JimBartlett_at_discussions.microsoft.com)
Date: 03/09/05
- Next message: Greg O: "Form filter works in 2000-2002 but fails in 2003"
- Previous message: fakeemail_at_fakeprovider.com: "Re: Form to Report Question"
- In reply to: Dirk Goldgar: "Re: use a list with checkboxes to select categories"
- Next in thread: Dirk Goldgar: "Re: use a list with checkboxes to select categories"
- Reply: Dirk Goldgar: "Re: use a list with checkboxes to select categories"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Mar 2005 19:47:02 -0800
Thanks for your help. I had pretty much decided that I would need an "In
between" table but haven't figued out how to make it work the way I want it
to. I am not necessarily married to the checkbox idea, highlighting would be
OK and would be even better if the selected items were at the top of the list
when the vendor record was reopened.
Thanks again.
Jim
"Dirk Goldgar" wrote:
> "Jim Bartlett" <Jim.Bartlett@sbcglobal.net> wrote in message
> news:0e5701c51d1f$8c41a070$a501280a@phx.gbl
> > I am writing a db for jewelry vendors. I want to
> > categorize the vendors by the type of items they sell.
> > Ex:
> > Bobs Jewelry - Watches
> > Franks Jewelry - Gold, Chains, Wedding Bands
> > Marys Jewelry - Diamonds, Rubies, Sapphires
> >
> > I have the vendor table and a Vendor Type table. The
> > Vendor type table has KEY, YES/NO, Type fields with the
> > data Watches,Gold,Chains,Wedding
> > Bands,Diamonds,Rubies,Sapphires etc.
> >
> > 1. I want to select the items by checkbox
> > 2. save them to the vendor record
> > 3. when I open the vendor record, I want all types to
> > show with the saved types checked and the others unchecked
>
> I think you really need three tables:
>
> Vendors
> VendorID (primary key)
> VendorName
> (other fields ...)
>
> MerchandiseTypes
> MerchandiseID (primary key)
> MerchandiseDescription
> (other fields ...)
>
> VendorsMerchandise
> VendorID (compound primary key)
> MerchandiseID (compound primary key)
>
> A record in VendorsMerchandise represents the fact that vendor
> (VendorID) deals in merchandise (MerchandiseID).
>
> Given such tables, you can certainly represent the data correctly and
> efficiently. All that's left is the user interface design. Normally,
> one would present the VendorsMerchandise table as a subform on the
> Vendors form, showing only the records on the subform that are related
> to the current Vendor record on the main form. However, that won't let
> you see all merchandise at once, nor select/deselect merchandise by
> clicking with the mouse. There's no built-in, code-free Access
> mechanism to do that, AFAIK, so it's necessary to write some code.
>
> Tell me, are you absolutely wedded to the idea of using a check box to
> select items? I know a way to do that, but the implementation looks a
> bit clunky to my eye. How would you feel about using a multiselect list
> box instead? The list box would show all the items, and the ones that
> are actually selected for the current vendor would be highlighted. In
> my experience, that looks a bit better than the calculated check boxes
> that are otherwise required.
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>
>
>
- Next message: Greg O: "Form filter works in 2000-2002 but fails in 2003"
- Previous message: fakeemail_at_fakeprovider.com: "Re: Form to Report Question"
- In reply to: Dirk Goldgar: "Re: use a list with checkboxes to select categories"
- Next in thread: Dirk Goldgar: "Re: use a list with checkboxes to select categories"
- Reply: Dirk Goldgar: "Re: use a list with checkboxes to select categories"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
