Beginning Design

[ASherbuck]

I've started work on a project, it's aspiring to become a Point of Sale but for the time being I'm focused on making sure that the inventory side of it is taken care of. I think I've got this set up decently. I figured I don't see this too often but attached is a picture of the table relationships I have right now, whatcha think ?

 

[Rabbie]

Hi You seem to have a lot of 1 to 1 relationships from the Items table. I would add an Item type field(Game,Music,Toy etc) to the Items tables to define what it is and then you will know which table to look at to get the relevant item details specific for that type.

I also notice you have a manufacturer table for toys but no similar table for Games,Music that I can see. You will probably need to have a supplier table for these items.

 

[ASherbuck]

Thanks for your response Rabbie.

I like that suggestion, with those 1 to 1's would Access be checking each specific table for a matching record when I run a query?

And before I jump in and try to implement it I am curious if this would be a way of doing such:

New table: TblItemType
1 Music
2 Movies
3 Games
4 Toys

Then link that to another new table that consists of ItemIDs and TypeIDs? Then relate the TypeIDs to the specific tables ?
Alternatively could I use my category and department tables to achieve this ?