I want to be able to select a Row and click the Edit button which will switch the View to the EditInventoryView.
I want the EditInventoryView to grab data that I have selected in the Table in InventoryView and pass it to the text/numeric fields in the EditInventoryView.
I missread where you had the embedded views on the same page.
On your table view, not the embedded one but the actual view that you made that page you need a ouptut parameter.
This value binds to where you get your part number from in the table.
One your view with the embedded views you will now see this value…
Then on your edit view, again not the embedded one but the real one where you created that page you need a input parameter… Yours would say PartNumberIn or what ever you call it.
Then on your embedded views you can bind the input parameter you get in the table embedded view with the output parameter in your edit embedded view.
In my example its id, yours would be PartNumberOut for example. so in the picture your binding PartNumberIn to PartNumberOut.
Clear as mud
Your have 2 options, get all the values you need from the table and pass them all as parameters, or just get the part number and use that as a sql so get the rest
Select ItemCode
From MyTable
Where PartNumber = {PartNumberIn}
In not sure on the exact syntax on that but that could be a named query using partnumber as a parameter.
Im not exact on this one, would need to try it out but you could use the same named query for all the results… Someone with better knowledge could correct me on this…
Select {XXX}
From MyTable
Where Partnumber = {PartNumberIn}
I would try to put the search bar at the top and the bottom and enable one or the other based on the device type. (You'll have to study to see if there's a property you can hook this into.)