John ---

Got your email, I'll look it over sometime this weekend and reply back to you via email before Monday AM....

>Thanks for the reply John
>
>The PmDesc table is related to Equip on Mfg(Manufaturer)+Model. The PmSched table is the one that I need to populate based on the following
>Find all pm's for all equipment
>exclude all that are currenly being worked on (open pm's in the PmSched table)
>exlcude any that are more than 30 days out
>take whats left and put it in a grid with a check box so I can check the ones that I want to apply to the PmSched table and print out the pm's that are put in the PmSched table.
>
>One problem I have is also when I create a new Pm or add another piece of equipment that already has pm's in the pmdesc table I need to make sure that I generate the pm's for the pmsched table even if that pmdesc has never been done before
>
>Or if you have another idea on how to do this I am all ears... or eyes
>
>>Hi John ---
>>
>>You're not giving us enough info, specifically what the relationship is between the "pm" tables and the "equip" tables....also, what mechanism populates the pmsched table would be enlightening....this could be a quickly resolved issue with more info :)
>>
>>>I am working a database to create a work order for each upcoming preventive maintenance for each piece of equipment. I am having trouble figuring out how to get from the tables the correct info.
>>>
>>>The Equip table has the Assetid, Mfg, Model, ...
>>>
>>>The EquipMtr table has the Assetid, Meter, ReadDate
>>>
>>>The PmDesc table has the PmId, Mfg, Model, Days, Hours, ...
>>>
>>>The PmSched table has the PmId, CompDate, CompTime, ...
>>>
>>>What I need is a list of PM's that are due in the next time period like 7 days. The Equip table has description of the equipment with the Assetid as the primary index. The EquipMtr table has the hour meter reading and the date of the reading for each piece of equipment that has an hour meter. The PmDesc table has each PM described based on manufacturer and model with the hours between each PM and or days between each PM. The PmSched table will have all the workorders for all the PM's and the complete date and time of the PM. So if a PM is scheduled but not completed it will not have a complete date. I could also put a complete flag if I need it. Can anyone give me some ideas?
>>>
>>>Thanks