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