Filtered Data will automatically appear in each filed in the Create New Data Screen

Question

Hi, I'm new in LightSwitch.

Is this possible in LightSwitch?

Here's the scenario:

I Have this tables created in my database: Table1, Table2, Table3

in my Table1 Data. The sample data stored are:

Id Name Year  Month Amount
1 Ken   2011  Dec  100
2  Joy   2011   Dec  150
3  Ken  2012   Jan  200
4  Joy   2012  Jan     50

Using the Customized Search Screen in LightSwitch, I filter the Data by Year & by Month.

and the Result: Filtered Data in Search Data Screen (Year: 2012 & Month: Jan)

Id FullName Year  Month Amount
1  Ken        2012   Jan     200
2  Joy        2012   Jan       50
 
Now, I need to click a Button and i want this filtered data to be open in List and Details Screen wherein the FullName is on the List and the rest of the columns will be on the detailed screen. When I click the Name of Ken and click edit, all the details of ken will be display in the Details Screen. My purpose of doing this is because I want to edit the Month to "Feb" and the Amount to a certain value for each of the name. Thus, After editing the data, when I click Save button, it will save to Table1.

Result:
Table1 will now have Feb Month

Id    FullName  Year   Month   Amount
1     Ken           2011  Dec      100
2     Joy           2011   Dec     150
3     Ken           2012   Jan      200
4     Joy           2012   Jan        50
5     Ken           2012   Feb      130
6     Joy           2012   Feb      115

Hope to here answer for this query.

Thanks.