Hello, I am having a bit of trouble understanding how I should set up some relationships.

So far I will have 3 Tables Mfr, Model, Procedures. (more to come, but just getting started)

The rules are a Mfr can not be duplicated, but can have many models.

Model numbers can be duplicated BUT a mfr, model combination can not. i.e. model 123 can be made by company ABC and XYZ, but an ABC 123 can only occur once.

A procedure can cover many models, but a model can have only one procedure.

So far I have.

MFR_Table
MFR_ID MFR_Name Website Phone etc.

MDL_Table
MDL_ID MDL_Num Description Price Image etc.

PROC_Table
PROC_ID PROC_Num (the document, or a path to the document) date, approval, revision, etc

So I guess I set a FK_Relationship between MFR and MDL, but I'm not sure how to handle the relationship between MDL and PROC applying the rules given above.

Am I even on the right track or does this require a different approach?

Thanks for any suggestions.