Table design

[directorz]

I'm having a tough time with what seems to be rather simple, I just can't see it and need a second set of eyes. I have the following arrangement in a vehicle maintenance db:

TblVehicles
ID - pk
VehID

TblServiceInfo
WorkOrderNo - pk
ID - fk to TblVehicles/ID
DateofService
Odometer

TblPMSchedule
Unit ID - pk
PMName - PK
PMInterval - PK
WorkOrderNo - fk to TblServiceInfo/WorkOrderNo

Here's the thought process.
1.TblVehicles is populated with info about vehicles...year, make, model etc.

2. Work completed on a vehicle is then entered in TblServiceInfo...oil change, replace wipers and the date completed.

3. I have broken down PM's into PM Names and intervals. What I need to show is the date that PM's (preventive maintenance items) were completed and associate a work order number with it. Seems that I can't do this until a work order number is first established, at which time I can then look it up, but that's after the fact. Does anyone have any enlightenment?

Thank you

Directorz

 

[directorz]

I'm getting off subject on this thread, I should start a new one