I have a database my tables are Project Bidpackage Contractor Project primary key is pID Bidpackage primary key is bID foreign key is pID Contractor primary key is cID foreign key is bID when a user select project it release the bidpackage base on the project and when a user select bidpackage it release only the contractors base on the bidpackage Here is my question. Did I set the foreign key relationship up right? I would like to now before I write the code for the make, model, year scenario.
What you have there seems fine, the project can have many bid and many contractors but bids and contractors can only relate to one project. If you should want something different - such as each contractor relating to more than one project then you will need a middle table to achieve the many-to-many relationship. Also, you currently have no relationship between the contractor and the bid. Does that fit your business rule?