Hi Folks
I am fairly new to asp.net. I have done stuff like this in access but not sure how to get it to work here.
I have 3 tables a Master,Detail,Item sort of relation ship.
I need to create a GridView of sorts that my users can see data that has been entered update it and or add data to the records easily. I would prefer a non click button method just click in the field edit when done editing all press save or what have you.
I am trying to figure out the best way to do this.
I have a Query and a Sub Query in access that pulls out the data I need so I would like to show it as an example.
The first query pulls out all the data for the team and year that are active
SELECT Impact_tblGoals.idGoal, Impact_tblGoals.GoalDescription, Impact_tblTeamIndicators.IndicatorName, Impact_tblTeamIndicators.IndicatorID, Impact_tblTeamIndicators.Active, Impact_tblTeamIndicators.FiscalYear
FROM I ...
Go to the complete details ...