I would like some advice.
We have one table which is basically a header table for MPO to track jobs in the plant.. then another table that gets data from timeclocks for each Mpo number and related data..
I want a view and ultimatley a report that I would run on this view to show all the mpos that do not have time put onto them. In other words Mpos entered into the system, but not yet started on..
General info in the header table I would like to collect would be Mponum, Itemnum, ShrtDesc,QtyOrd,Location,shopordr
and then the table of time tracking we have Mponum,WrkDate,WorkHrs,OTHrs,DTHrs,ClockNo
Can someone give some suggestions to break this fog I'm in..
I know this is so simple it's going to make me kick my can when I see it, but I've had one of those head in the cloud days..
Thanks for input Jim Limburg
