A family of Microsoft relational database management systems designed for ease of use.
Ok so I have my Product table
ProductID (FK)
SupplierID (FK)
ProductName
BUT when I try to save it, it says ' Index or primary key cannot contain a null value'.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Creating a Product Inventory database to keep track of all the promotional items my company has. So far I have three tables: Suppliers, Inventory, and Event. In my Inventory table I have the following columns (in order): Product ID, Product Name, Description, Logo, Color, Size, Total Quantity, Supplier, Event, and Storage. There are so many different styles of shirts that we have accumulated over the years that for every shirt style there are multiple sizes and sometimes multiple colors. So with that, I have choosen to add the size and/or color to the product name as well as in the size and color columns.
For example:
Men's Wicking Polo: Small S
Men's Wicking Polo: Medium M
Blue Crinkle Cut Paper Blue
Purple Crinkle Cut Paper Purple
Will this create a problem? I didn't know how else to set it up because it didn't think the database would recognize that five Crinkle Cut Papers are different colors (making it five individual products because of the colors), if the product name on all of them is the same.
One more: I tried to run some relationships like between the Suppliers table and the suppliers column under Inventory but it didn't work.
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Ok so I have my Product table
ProductID (FK)
SupplierID (FK)
ProductName
BUT when I try to save it, it says ' Index or primary key cannot contain a null value'.
Yes Supplier is an attribute of Product so its should be a FK in the Products table. Same thing with Logo. However, Event is an attribute of when the product is used. It would also be a many to many relationship. An event can have many products and products can be used at many Events. So you would need a junction table to manage that relationship.
Starting my new database. I have a suppliers table. Under the Products table would the SupplierID be a foreign key?
Products Table:
ProductID(FK)
ProductName
SupplierID(FK)
Where should my Logo and EventID fields go? in the products table or inventory table? I have a logo field because we have two different logos we use and I want to be able to know which has what on it. I created a seperate event table. Am I suppose to do that?
Thats for the suggestion, but that is way more advanced than I want to take it.
As a first timer, did you look at the Northwind 2007 template?
http://office.microsoft.com/en-us/templates/desktop-northwind-2007-sample-database-TC001228997.aspx