I have a document library containing 100's of business cases as well as their related documents. The Content Type is set to "Business Case" for the primary document and to "Supporting Document" for all other related document. Currently only the Business Case itself has all the status and date columns filled in. The default view is grouped by business case ID so the business case and supporting documents (if any) apprear together.
All good to this point. However when trying to filter our business cases in the view that are "closed", the supporting documents still appear because they have no status in them. Any idea how I can either automatically update status of related supporting documents when the business case is closed, or amend the view in such a way that it excludes supporting documents if the related business case is closed?
Cheers - Brett