How NOT to update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several tables of "master data" that feed into a "Daily Roster Report"
of assigned route drivers, routes and truck assignments and scheduled start
times.

I need to be able to update the Daily Roster Report each morning to refelct
any route changes caused by absence, truck breakdown, tardiness, etc. but do
NOT want to change the underlying, master table data.

Help!!

Thanks
 
MikeARC said:
I have several tables of "master data" that feed into a "Daily Roster
Report" of assigned route drivers, routes and truck assignments and
scheduled start times.

I need to be able to update the Daily Roster Report each morning to
refelct any route changes caused by absence, truck breakdown,
tardiness, etc. but do NOT want to change the underlying, master
table data.

Help!!

Thanks
Click to expand...

Then you need another table that stores what *actually* happens each day and
only use the Master table to supply default values to that table which once
copied over can be changed for that day.
 
Back
Top