I have two lists
1) List for the characterisation of a Product
2) List for the production of a Product after characterisation
For rudimentary access permissions reasons these need to be two seperate lists for my purposes.
I have a requirement to have an area in SP where a senior manager can view anything that's had it's characterisation completed and move items of interest into List 2 by way of a 'request'. I have created a site page around list 1 that will fulfull this requirement (all through views of fields in list 1) that also has a column with a hyperlink to the 'new item' form for list 2 for the request. This hyperlink is in the table alongside each individual item.
What I want is for the name of the product to be autopopulated from list 1 when you open the 'new item' form for list 2 through this hyperlink. Is there a way to do this using the solutions I already have above and staying within SP Designer (no added downloads)? Is there potentially a better way to tackle this whole problem?
If there is a solution for this can it also be done without too much in depth manipulation of code?