I am designing a way in Access to track parts that have been added to a specific aircraft. Parts have a consumption in Hours, Days, and Cycles. Parts have a lifespan in Hours, Days and Cycles.
One table I have is: [NNumber] (an associated foreign key in the Aircraft_Table) , [PartID] (AutoNumber Primary Key) , [PartName] , [Part#] , [Serial#] , [Manf] , [DateInstalled]
Another table is: [PartID] (Foreign Key to associate it with the table above) , [InitialHours] , [InitialCycles] , [InitialDays]
And yet another: [PartID] (Foreign Key to associate all parts together) , [LifeHours] , [LifeCycles] , [LifeDays]
I was thinking of creating a Main Form with the first table listed and having subsequent sub-forms off of that.
All that is needed to do is generate reports that show, say on a specific aircraft, which parts are coming due for servicing. Thanks in advance for any suggestions!
One table I have is: [NNumber] (an associated foreign key in the Aircraft_Table) , [PartID] (AutoNumber Primary Key) , [PartName] , [Part#] , [Serial#] , [Manf] , [DateInstalled]
Another table is: [PartID] (Foreign Key to associate it with the table above) , [InitialHours] , [InitialCycles] , [InitialDays]
And yet another: [PartID] (Foreign Key to associate all parts together) , [LifeHours] , [LifeCycles] , [LifeDays]
I was thinking of creating a Main Form with the first table listed and having subsequent sub-forms off of that.
All that is needed to do is generate reports that show, say on a specific aircraft, which parts are coming due for servicing. Thanks in advance for any suggestions!