My question here is, is it possible to pull information from an item (say a checked-in text file) to be used within another item that is being created based upon information entered within certain fields? This is an integrated review tool/item that will ultimately parse through a set of checklists and allow the user to select one of three that are available, for example.
The overall idea is to have a review tool that contains fields with various information on the first tab, then another tab containing a checklist. The problem here is that we have lots of checklists and depending upon the information filled out on the first tab, it would change the picklist containing the checklists on the checklist tab. Once the checklist is selected from the picklist, it would need to be editable. However, we do not want the checklist to live within this review tool as this causes unnecessary maintenance if the checklist is updated. We want the tool to pull from another area within MKS where all the checklists are currently stored as .txt files.
OK, I think I get it 😉
In you case I'd implement a IM pre trigger taht is fired when the value of you picklist changes.
Inside the trigger script you either
In both ways you would only have a "one way" relationship like COPY ON CREATION between your txt-file in source control and your review item.