Chris__T
Posts: 339
|
| Posted: 07/18/2007, 10:42 AM |
|
Hi all.
I have an editable grid that pulls data from table A. There are blank fields on the editable grid that I add data to, and when I hit the "submit" button, would like to have this editable grid's info (with the new data I just added) added to Table B as new records.
ex. of editable grid
Name Hours worked Date
Joe 7/18/2007
Pete 7/18/2007
Mary 7/18/2007
simplified version above.....I pull Joe,Pete,Mary from Table A to Editable grid.. Hours worked is blank. Date is currentdate
I now add my info to hours worked.....
Name Hours worked Date
Joe 8 7/18/2007
Pete 7 7/18/2007
Mary 8 7/18/2007
and then I want to hit the submit button, and have this new info (name, hours worked, date) to go to Table B as new records. Because the next day they will do this again and add their name and hours worked for the next day (and Date will be incremented to 7/19/2007). This way , table B holds their timesheet information.
Been trying to figure this out and it seems like editable grid wants to just update. I have it sending the info to Table B, but it just wants to update the records with the new hours information, it's not sending as new records.
|
 |
 |
Chris__T
Posts: 339
|
| Posted: 07/18/2007, 10:44 AM |
|
well, my tables looked clumped together. First table example should be spaced out so hours worked is blank. 2nd table example should be Pete.....8.....7/18/2007 and so on.
|
|
|
|
|
