Question About Initial Form Layout

PhilG

Registered User.
Local time
Today, 03:09
Joined
Jan 15, 2012
Messages
13
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!
 

Users who are viewing this thread

Back
Top Bottom