jfiorini
08-19-02, 16:34
| I am creating a database for a factory that contains three tables: one with a list of Lines that are currently running, one of Support Departments that are running and one for Product Types that are made on each line. The problem that I found is linking the Product Type table back to the line/support department tables. I have a Primary Key LineId in the Line table and SupportDeptId in the Support Department table. I would like to only have one foreign key in the ProductSize table, but the only way I can find to do that is to create a middle table with lines and/or support department ids, and to link through that table. Does anyone have any suggestions? Thank you, Joe Fiorini |