Choosing from Multiple choices in a table

[Guest]

I have a question how to read a table with multiple choice to pick...I'm sure
this is a simple answer for some of you that's why I'm here...it's not simple
for me....LOL

I have 2 tables, 1 with my vehicles and their toll classification.
If I'm a passenger car I'm a class 1
If I'm a van I'm a class 2
If I'm a crane I'm a class 3....etc..

So If I classify the vehicles with a class code .....then I need to go for
the toll fare based on where I get on at.

I have to download these toll fares from the internet and it's not easy. I
was lucky I got what I got. I have to think about how to download these
tables everytime they have a toll fare increase also.

the 2nd table is the toll fares by classification.

My employee chooses the entrance ramp he got on and off from the toll fares
table and I need to read the vehicle table to figure out which classification
(ClassCode) he was at in order to pick the correct amount of money under a
classification on the toll fare (currency).

Vehicle table:

VehicleID (auto)
ClassCode (number)

TollFare Table:
TollFareID (auto)
EntranceRamp (Text)
ExitRamp (Text)
ClassCode1 (currency)
ClassCode2 (currency)
ClassCode3 (currency)

I then need to store what was choosen to print to a report to be used in the
office for billing purposes.

I have a table called VechicleUsed right now that stores the TollFareID but
how do I store or have the correct amount print?

My form has a 2 comboboxex, 1 for the vehicle and then 1 for the tollfare
Entrance. It shows the Entrance name and the Exit names and all the toll
fares in columns.

 

[Douglas J. Steele]

Your TollFare table shouldn't be storing the 3 rates as 3 separate columns.
Instead, you should be storing 3 separate rows, one for each ClassCode:

TollFare Table:
TollFareID (auto)
EntranceRamp (Text)
ExitRamp (Text)
ClassCode (number)
TollFare (currency)

Once you have it structured that way, hopefully it's obvious to you have you
can get the correct TollFare.