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