All Data filter

[#1]

I have 3 tables:

Building --< Material --- InStock

--< One-to-many; --- one-to-one

Building: BuildingID

Material: BuildingID, MaterialID

InStock: MaterialID, InStock

Selecting InStock='Yes' filters to Buildings that have any number of Materials in stock. How do I show only Buildings where ALL materials needed for that building are in stock?

Any ideas?

Daniel

[#2]

Hi Daniel,

By using Joins U wil b get wat u want.

Warm Regards,

Sri