Can someone suggest form layout

[dean welch via AccessMonster.com]

just wondering if someone can suggest a form layout for my database i have
created.

database tables, fields and relationships are as follows,

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.

any help would be greatly appreciated.

 

[Michel Walsh]

Hi


Some details are not right. Table "tblRace" ( I prefer no prefix, and plural
mark: Races ) is not defined. tblCarSetup does not seem to be used
anywhere. Engine compression is "variable" ( I am not expert in that
matter)? if not, that should be moved from EngineSetups to Engines.

Your last table seems strange. As example, RaceID is part of Events and of
RaceMasters. And Events is part of RaceMasters, but that makes a triangle,
for RaceID, and that is an indication that something is maybe wrong. Why not
removing RaceID from RaceMasters?


RaceMasters
------------------
EventID --------> Events | EventID
RaceID ----------------------> RaceID



Hoping it may help,
Vanderghast, Access MVP