I have two lists:
- List A: Products
- List B: Requirements
I'd like to have a nice Create Requirement page launched from the Product Listing page.
I have a DVWP/Multi-Item View displaying all Products. Next to each product, there is a Create Requirement link. The hyperlink generates the Query String URL /Pages/Create-Requirement.aspx?Product=Product
On the Create-Requirement.aspx page, I have a DVWP/New Item Form. The form includes a lookup field back to the Products list. I would like the Query String parameter to populate that lookup field and for the field to be hidden.
Hiding the field should be easy enough - I just can't make the lookup happy. (Lookups are never happy.)