Table for Car Gear Ratios

[TobyR]

Hi,

I am creating a table with gear ratios, the struction of my source data is as thus:

Gear Number | Gear Ratio | Top Speed in Gear
1st | x.xx | xxx
2nd | x.xx | xxx
3rd | x.xx | xxx
4th | x.xx | xxx
5th | x.xx | xxx
6th | x.xx | xxx
7th | x.xx | xxx

Final Drive x.xx (opt x.xx)
Reverse x.xx
Shifter, Stick, etc: Stick, 5 speed
Shifting Speed: Medium Slow

I'm stuck on how I would present the gear ratios etc in an Access table? Obviously have a column for each gear would be bad database design.

Any help you could give would be most appreciated.

Thanks very much.

Toby R

 

[alastair69]

If i was developing the software i would have seperate table for the gears layed out something like:

ITEM = Gear| GearID = AutoNumber
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5

Then creat a link with your main table link to GearID.

Alastair

 

[TobyR]

Hi,

It's getting a bit much now! I'm am storing all the data i know about certain cars, I have 18 tables at the moment (Separate tables for Brakes, Chassis Details, Downforce, Driveline Type, EngineConfig, Engine Tuning, Manufacturers, Models, Notes, Overview, PerformanceSummary, SuspensionSetup, Tyres, and Vechicle Types, my main table is Vehicles which holds the Year, Cost, Model, Submodel, Picture and Production Date) I also have tables which hold values for certain fields in the tables like EngineTypes (V, IL, Flat) and EngineLocations (Front, Rear, Middle) and DriveLineTypes which is 4WD, FWD and RWD... Is it right to have this many tables?

 

[alastair69]

IF you want i can have a look at your Database if you can post it on here and i will look into the best method for what you are tring to acheive.

Alastair

 

[TobyR]

Sorry, afraid I can't, any other way I can communicate the structure to you?

 

[alastair69]

Is it due too the file size?

 

[alastair69]

It would appear that you have too many tables

 

[alastair69]

You could have a look at this posting i know it is not exactly what you have ask but it may help.

Link http://www.access-programmers.co.uk/forums/showthread.php?t=81781&highlight=racing+cars

 

[TobyR]

Ok,

Here are my tables:

tblVehicles (This is where 'pkCarID' comes from, this is my main table)
pk, txtVehType, txtManfacturer, intYear, curCost, txtPrimaryCountry, txtSecondaryCountry, txtModel, txtSubMode, oleVehiclePic

tblBrakes
pk, pkCarID, txtABS, txtStabCont, txtYawCont, txtBrakeBehavior

tblChassicTuning
pk, pkCarID, intWeightDistributionFront, dblWheelbase, intTrackFront, intTrackRear, txtCofG, txtDragCoefficient, dblFrontalarea, txtDownForce, txtDrivelineType, txtLimitedSlip, txtSuspensionSetup, txtTCSSystem

tblCountries (List of Country Options)
pk, txtCountry

tblDownforce (List of Options for Downforce field)
pk, txtDownforce

tblDriveLineTypes (List of Options for Driveline field)
pk, txtDriveLineType

tblEngineConfig (Engine Configurations)
pk, txtEngineConfig

txtEngineLocs (Engine Locations)
pk, txtEngineLoc

tblEngineTuning
pk, pkCarID, intEngineSize, dblPublishedPower, dblPeakTorque, intRPMPeakPower, intRPMPeakTorque, intRedline, txtEngineType, txtCylinderConfig, txtConfiguration, txtEngineLocation, intTurboRevMin, intTurboRevMax, intTurboBoostPRessure, oleTorqueCurve (Pic of torque curve)

tblEngineTypes (List of Types of Engine)
pk, txtEngineType

tblGearTuning
pk, pkCarID, dblFinalDrive, dblReverse, mmShifterStick, txtShifterSpeed

tblManufacturers
pk, txtManufacturers

tblModels (Table with model names in, there is a submodel field so best to keep these in a table so they can be selected again
pk, txtModels

tblNotes
pk, pkCarID, mmNotes

tblOverView
pk, pkCarID, txtBriefHistory, txtReferences

tblPerfSummary
pk, pkCarID, mmDrivingTraits, dbl060, dbl100, dbl150, int600slalom, int700slalom, dblTopSpeed, txtGearAeroLimited, dblQuarterMileTime, dblQuarterMileSpeed, dblStandingMileTime, dblStandingMileSpeed, dbl600, dbl700, dbl800, dbl200SkidPadG, dblSkidPadG

tblSuspensionSetup (List of values that can be used in suspension table)
pk, txtSuspensionSetup

tblTyres
pk, pkCarID, dblFrontSection, dblFrontAspect, dblFrontRim, dblRearSection, dblRearAspect, dblRearRim

tblVehicleTyres (This is a list of types of vehicle, Car, Bike, Truck, etc)
pk, txtVehType

 

[GRose]

Not an answer but are you compiling a database for all the cars in GT4?

 

[TobyR]

Not an answer but are you compiling a database for all the cars in GT4?

No, Sorry!

I'm having trouble refreshing a combobox, I have a button on a form to add a new manufacturer... When that form is closed I want to refresh the combobox on my form when clicked to display the new manufacturer...

Any way of doing this?

 

[GRose]

I use this on the On Close event

Forms![formnamehere]![subformnamehere].Form![comboboxnamehere].Requery

You can remove the ![subformnamehere] part if it doesn't have a subform:

Forms![formnamehere]Form![comboboxnamehere].Requery

Works fine for me.