northwind traders sample database combo box

[vicsaccess]

I've been looking at this sample database that comes with Access and am stumped at how they did something. I am looking on the product details page that you go to if you click on a product from the main page. there is a combo box for supplier that I like and would like to learn how, but I can't see where there is a difference from normal. maybe its simple to the experts but I have not seen this done yet. when you click on the combo it drops down to a selectable list with check boxes and a footer with a "OK" and "Cancel" buttons. anyone know how its done. I've compared all the properties to my test combo box and can't replicate it.

[June7]

Sounds like combo is bound to a multi-value field. I NEVER use multi-value field.

[RuralGuy]

After digging deeper I've come to the conclusion it is because it is a Multi-Valued field. Here's a page that sort of describes what we have: https://support.office.com/en-us/article/Add-or-change-a-lookup-column-that-lets-you-store-multiple-values-63834360-2D63-4E13-8499-A62B47A4EE27

[RuralGuy]

Actually it is a Lookup Field that is pointing to a Multi-Valued Field. Now we know what they look like. I too do not use Multi-Valued Fields.

[vicsaccess]

thanks guys and thank you ruralguy for the link. time for more studying. looks like I will be a good resource to use at times.

[vicsaccess]

ok, never mind. looks neat for the user but breaks normalization and creates more issues on the backside.

[RuralGuy]

I would agree but here's another take on the same subject: http://www.kallal.ca/Articles/fog0000000006.html