selectable grid

Question

Hi, 
 I have a requirement where, I have to be able to show the goals for a employee to resubmit as a step after he selects and submits the goals for the first time incase, he/she needs to add/remove any. The local variable 'FunctionalGoals' contains the list of master data as a type from which they can choose goals(1st cdt). It has only goaltype, subtype as columns in this case. The 2nd local variable 'SubmittedFunctionalGoals' contains the goals that have been submitted for the 1st time by the employee(2nd cdt - Transaction table), This has the remarks and startdate and enddate columns. There is a 3rd local variable 'SelectedFunctionalGoals' Which has the new goals which the employee selects (storing this as I need to make the respective remarks and startdate, enddate editable and required for that row). so fetching the remarks and startdate and endate for the submitted goals(1st time selected goals) is what I am stuck with. 
 Hope I am able to convey the issue properly as its a bit complex. 
 Thanks in advance

Mike Schmitt · Answer

I'm not sure what you're trying to do here with your SelectionValues and SelectionSaveInto. 
 Both of these parameters are intended to deal with identifiers of selected rows . Firstly they should (at least eventually) reference the same local variable, and secondly, you seem to be overcomplicating it. 
 Beyond that, can you clarify as to what exactly the issue is that you're having?

Naresh · Answer

Hi, 
 As Mike mentioned, didn't understand what is your exact issue. Are you trying to find the remarks, start date and end date that user submitted first time with association goaltype and subtype. If yes, is there any relationship between Golas and SubmittedFunctionalGoals like primary key or florigen key relationship? based on that you might find the solution you are looking for.