Hi All,

I'm having a few dilemma's about designing the following tables of a DB.
Or more to the point am unsure how these relationships work.

Suitabilty is linked to a Summary table via a foreign key.

Suitablility - Partchment - Reccomended
Acceptable
Further research
Not tested
Failed.
Lights - Reccomended
Acceptable
Further research
Not tested
Failed.
Gloss - Reccomended
Acceptable
Further research
Not tested
Failed.
Bucket - Reccomended
Acceptable
Further research
Not tested
Failed.

Any assistance would be rad!

Cheers, William

Suitability - Gloss - Reccomended
Suitability - Gloss - Not suitable
Suitability - Gloss - Failed
Suitability - Gloss - Not tested etc..

Suitability - Lights - Reccomended
Suitability - Lights - Not suitable
Suitability - Lights - Failed
Suitability - Lights - Not tested etc..

Cheers, W.

I suggest you talk to your classmates or your instructor.

Perhaps my question was a bit flawed but that response SUCKS!

Who do you think you are!

W.

tcom, please be aware that these forums are moderated and that the type of response you posted is unacceptable

you may feel free to express your unhappiness with the response given by certus, but please do so in a more civilized manner