We are running 3.8.8. We have some custom fields we would like to auto-populate using scripts. Basically, like so:
customfield id = 1 - Client/Project customfield id = 2 - Task/Code In the create new ticket form, the data in Task/Code is dependent on what is chosen in Client/Project. I cannot for the life of me figure out how they are related within the database structure. I know it has to do with the sortorder in customfieldvalues, but I cannot see where they are related. We want to script on the backend updating the information based on data that pulls from another database. We hav the data to load, just need to figure out how to relate them. Any ideas? Thanks in advance! Joe -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 & 27, 2011 * San Francisco, CA, USA October 18 & 19, 2011 * Washington DC, USA October 31 & November 1, 2011 * Melbourne VIC, Australia November 28 & 29, 2011 * Barcelona, Spain November 28 & 29, 2011