How NOT to update

[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

 

[Rick Brandt]

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

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.