Quote:
Originally Posted by twinkiejr
Maybe I am doing this wrong should the foreign keys be placed from the inventory to the other tables?
|
no, that'd be wrong
you said you can still put any combination of the fields in the inventory table, so that means you haven't declared the FK from the inventory table to the year/variety table properly, because it's the year/variety table which controls the combinations