I
ispy99
I work on a fairly large engineering program and have created a database with
multiple tables of metrics. Basically each table covers a different part of
the system. Aside from the fact that all the data relates to the same
overall system, the only tie between the tables is the date. I need to
create a snapshot of the system, a form showing plots from the various tables
on the same form. I can't seem to do this. The closest analogy I can come
up with is a report for, say, a grocery store. The report might contain
number of transactions, average temperature (to see if it affected sales),
list of sales for the day, etc. Then I wanted to be able to chose the date
or period of time and update all the charts.
Any suggestions?
multiple tables of metrics. Basically each table covers a different part of
the system. Aside from the fact that all the data relates to the same
overall system, the only tie between the tables is the date. I need to
create a snapshot of the system, a form showing plots from the various tables
on the same form. I can't seem to do this. The closest analogy I can come
up with is a report for, say, a grocery store. The report might contain
number of transactions, average temperature (to see if it affected sales),
list of sales for the day, etc. Then I wanted to be able to chose the date
or period of time and update all the charts.
Any suggestions?