Form Suggestions

[dfwcomputer]

Can anyone suggest a good form layout for my database below?

I have also included the database in access 2002 version!

tblEvent
EventID (int autonumber not null primary key)
RaceID (int foreign key to tblRace.RaceID)
EventName
EventTrack
EventDate

tblCar
CarID (int autonumber not null primary key)
CarName

tblCarSetup
CarSetupID (int autonumber not null primary key)
CarID (int foreign key to tblCars.CarID)
TyreType
TyreSize
GearBox
DiffRatio


tblDriver
DriverID (int autonumber not null primary key)
FirstName
LastName

tblEngine
EngineID (int autonumber not null primary key)
EngineMake
EngineModel

tblEngineSetup
EngineSetupID (int autonumber not null primary key)
EngineID (int foreign key to tblEngine.EngineID)
EngineCompression
Carburetor
FrontJets
RearJets
FuelPressure
BaseTiming
TotalAdvance

tblRaceVariables
RaceMasterID (int foreign key to tblRaceMaster.RaceMasterID)
RaceTime
TrackTemperature
RelativeAltitude
Milibars
Humidity
AirTemperature
TyrePressureHot
TyrePressureCold
StageRPM
ShiftRPM
Reaction
60ftTime
330ftTime
660ftTime
660ftMPH
1000ftTime
ElapsedTime
ElapsedMPH
Coments

tblRaceMaster
RaceMasterID (int autonumber not null primary key)
EventID (int foreign key to tblEvent.EventID)
CarID (int foreign key to tblCar.CarID)
EngineID (int foreign key to tblEngine.EngineID)
DriverID (int foreign key to tblDriver.DriverID)

All relationships will be RI Link with delete cascade.

Thanks,

Dean

 

[dfwcomputer]

This is a sample of the database including forms let me know what yous think?

Dean

 

[dfwcomputer]

help with form layout

any ideas guys?