I have tried this in Visual Studio 2008 but since my knowledge in this is limited. I reverted back to Access.
I have been reading all of the posts on cross tabs. . .queries and forms. I understand you cannot edit a crosstab query (although all of my data is perfect in that format - with no subtotals or groupings. . .ugh) I have read posts on making a cross tab form, but nope, I cannot seem to edit that either (still trying though with a db sample someone posted.)
Here's what I have. . . thinking outside the box would be great!
I have an ERP system (SQL database) that has a resource scheduler that does not work the way we want it to. So, I want to export the data, and let my scheduler person edit it, and then push it back into my ERP system.
This is what the existig table looks like . . . .
Part Resource StartDate Hours
123 mach1 6/28/10 19.5
123 mach2 6/30/10 51.0
123 mach3 7/6/10 51.0
456 mach1 6/28/10 6.0
456 mach2 6/29/10 16.0
456 mach3 7/1/10 12.0
What I would REALLY like is a form that she can edit (drag and drop would be perfect - cut and paste is fine) to make the schedule as we want it, and then update my ERP.
Part Resource 6/28/10 6/2910 6/30/10 7/1/10 7/6/10
123 mach1 19.5
123 mach2 51.0
123 mach3 51.0
456 mach1 6
456 mach2 16.0
456 mach3 12.0
What would be ideal . . is if she moves hours from one date to another, the entire part backwards schedules. . .but that will be another question! I have the crosstab query (not editable), and I have a crosstab form (I thought I could get it to edit based on what I read, but no-go. . . )