Dataset question - need LOTS OF HELP
Posted on 2004-04-23
I hope someone can help me because I am So LOST!
I'm using design time databinding ...etc.
So I have a few tables I need to work with:
Downtime Shift Operator downtimedetails
----------- --------- ------------ --------------------
downtimeid shiftid operatorid downdetailsid (autonumber)
entrydate shiftname operatorName downtimeid (link to downtime table)
operatorid all other info
I'm using a tab page. On tab page 1 The user enters records during the day/shift... so many entry's during a shift. So during the day they are going to enter downtime information.
When the user selects the downtime tab, if a downtime record exists for a particular date and shift that they are currently entering, then I set my detail dataview to the appropriate settings.If it doesn't exists it creates a record for that day and shift. Then I have a datagrid bound to my dataview to show the downtime details for the current day/shift they are entering.
However, I want the user wants to be able to manually go through the downtime records and see the different days and shifts details, I'm having trouble doing this part.
So on the second tab page I want to show Operator Name, Shift Name, Entry Date, as Labels ... and have the grid show the details. When they click next they should be able to go from let's say May 1st Night shift to May 2nd day shift ... and so on.
If someone can help me ASAP I'll even reward an extra 500 points.