Question: I need to create a validation table with a list of our training instructors. The validation table needs to be linked to the “Instructor” field in the set-up > Sessions > Details page. Any information you can share with me is greatly appreciated.
Solution: This can be accomplished using the emPath site_ComponentMetaData feature in combination with a minor XML change. The result is a dropdown box tied to a custom validation table. Following is an example using the (training > set-up > Sessions > Details) page.
Following are the steps involved in the custom shown above:
(1) Create or modify at site_ComponentMetaData xml file in which you edit the TrSessions component as follows.
from: <field name="TR_INSTRUCTOR" table="TR2">
to: <field name="TR_INSTRUCTOR" table="TR2" type="validated" table-code="ZINSTRUCTR" />
(2) Modify the TrSessionDetails xml file as follows:
from: <input type="text" class="edit" id="txtTrInstructor" name="txtTrInstructor" />
<span class="view" id="spnTrInstructor" />
to: <select type="text" class="edit" id="txtTrInstructor" name="txtTrInstructor"> </select>
<span datafld="TR_INSTRUCTOR" class="view" id="spnTrInstructor" name="spnTrInstructor" ></span>
(3) Using the emPath (setup -> validation tables) page add instructors. Following is an example:
(4) Delete the CTrSessionDetails file from your nsl63 cache.
(5) End the aspnet_wp.exe process (if you run Windows 2000) or the w3wp.exe process (if you run Windows 2003).
That is all there is to it.