I have tried using foreign keysfrom the three tables talked about earlier using the fields (*)# and placing them in the inventory table but this does not seem to limit anything. I can still put any combination of the fields in the inventory table. Maybe I am doing this wrong should the foreign keys be placed from the inventory to the other tables?

Thanks for the quick responces they are really appreciated.