How to structure database

I am building a database to record "Tire Measurements" for Heavy Equipment.

Some equipment can have 8 wheels, some 10
In the trade these are identified as "positions"
L/F (Left Front)
R/F (Right Front)
L/R (Left Rear)
L/R/I (Left Rear inner - Rear most axle, left hand side, inside most postion -)
R/R (Right Rear)
R/R/I (RIght rear inner - you get the idea)

Some buses also have two additional wheels
L/T ( left Tag -tag being the name of the secondary axle which has one tire on each side)
R/T ( Right Tag )

I want a simple way for the assistant to input new measurements since it will be done allot.
A simple userform where you just display unit number ( type and hit enter to look it up )
It needs to show each WHEEL POSITION and the last date it was measured for each POSITION.

I made one main table for #unit Number#, #date#, #Measurement", "Postiion"

Not really sure on how to structure with another table, and lookups for newest dates in each position.

Thanks for any help.

Todd

Dennis7849

The last line of your post sounds to me like a solicitation for paid work, so I've deleted it.
This is not the first time you've been warned about it. The only reason I haven't banned you for it is because I'm not 100% sure.

Your input into this forum is very much appreciated, but if you help someone, you do it for free. Not tell them you'll help more if they pay.

DominicB