Recent content by mrnorman

Unfortunately, I didn't set the requirements for the DB. I'm simply following instructions as part of an exercise. The more I think about it, the more I think the intention was for me to create separate (but identical) records for products so that they may have unique Supplier IDs for me to...

Here's the current setup: Supplier: ID Vendor Name Contact Name Phone Email Product: Brand Description Vendor ID I need to adhere to that structure, but generate the previously mentioned report. If I'm not mistaken, in the combo box scenario I'd still have multiple values in a single field...

While I certainly appreciate the response, I feel as though it's beyond my understanding. Perhaps a more appropriate question would be: What is the proper way to set this up? If I have a need to display a report which groups Products by Vendor and some products MUST be sold by multiple vendors...

Hello, I've current got two tables, one with Products and the other with Suppliers. The products table has a column in which I may indicate Supplier IDs that carry the product. I'd like to make a report that groups the Products by the Supplier that carries them and I'm having some trouble. The...

Hello everyone, Lurker turned member looking to get a few questions answered and hopefully give back at some point.