Sorry if I was confusing. I was not sure how to phrase the question. So I came up with a fictious example. Based on the responses I got my fictious example only made things worse. What follows is another (hopefully better) fictious example that explains my question.

I have a Master/Detail relationship. My business rules state that there must be at least one Detail Item for each Master Item. From experience I know that 99% of the time that there actually is only One Detail Item for each Master. It is very rare that a Master Item will have more then one Detail Item.

The Detail Table Has the following Fields:

MasterID

Sequence Number

FieldA

FieldB

Since I know that I always have to have one Detail Item for each Master and that almost all of the time that there is only one Detail item, would it be a good or bad idea if the Master table contained the fields FieldA and FieldB? This way I would only have to concern myself with the Detail table on rare occassions?

Thanks