Partially Pre-populate InsertItem with Secondary Datasource
Posted on 2007-03-21
I have one field in a Formview's InsertItemTemplate that I would like to pre-populate from a datasource other than the one that is bound to the FormView.
The details are as such: my main page allows a user to create a new relational record for a customer. When a button is clicked to create this new record a formview is presented in a new window. The URL contains two query parameters, editorWorkorder.aspx?id=new&companyId=232 . The id=new puts the formview into Insert mode, and the companyId=232 determines should be saved along the new workorder so I'll know what company the new workorder belongs to.
Everything works fine. However, I realized I would like to display the company's name in the formview while it is in Insert mode to remind the user what company the workorder is being created for. Also because I just really, really want to.
I can retrieve the company's name through another query, but how would I get the name to display in a label inside the formview while the formview is in insert mode and bound to a differnt datasource than I am retireving the company name from?