Re: Historical info for line chart.

You would need a record created for each weekly snapshot.  An Automaton would run a saved Table to table copy each weekend to copy the jobs into the History table. But you would only copy a few fields that you need for the charts and they can be children of the job, so you don't need to copy any fields that can be looked up, like [Job Name].

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------