How to Search Table for Related Records in the Same Table
Posted on 2010-11-10
I have a table of documents. These documents come in, are reviewed, comments are posted and revised documents are posted. All these documents should be in the same table.
Documents are named by Task Order and Document Type:
When I scroll on any of the documents with ABC-INTRO, I want to see the list of the other document names and their due dates in a portal.
Each record has a field called Task Order and Document Type so each record above has ABC-INTRO in the field.
Nothing is showing up in my portal.