I have a database my tables are
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.
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?
answered Dec 27 '10 at 05:46 AM