Consistency Check

[JLD]

I have three tables linked together. Table one is Property, Two is
Improvement and Tbl Three is Improvement Segments. They are all linked
together by a property Id and year.

For each Improvement there is at least one Improvement Segment with a field
called 'class' in the Improvement Segment table. There numerous segments in
the Improvement Segment table and each of the segments should have the same
class.

My question is how can I get a search that will tell me if there are any
improvement segments that the class is not consistant for each of the
improvements from Improvement table.

Hope this isn't too confusing...Thanks! I need this badly.

JLD

 

[John W. Vinson]

For each Improvement there is at least one Improvement Segment with a field
called 'class' in the Improvement Segment table. There numerous segments in
the Improvement Segment table and each of the segments should have the same
class.

My question is how can I get a search that will tell me if there are any
improvement segments that the class is not consistant for each of the
improvements from Improvement table.

Well... if the Class depends on something other than the segment, then I'd
suggest that the Class field *should not exist* in the Segment table. A basic
relational principle is that each field in the table should depend ONLY upon
that table's primary key.

Perhaps the Class field should be in the Improvement table, rather than in the
ImprovementSegment table. Then there'd only be one, and it would automatically
be linked to all the segments. Is this a feasible change to your structure?

John W. Vinson [MVP]