I have 3 tables

"cars" with: carID, driverName

"drivers" with driverID, carID, and misc. fields

and "deliveries" with orderNumber, fk_carsID

I'm trying to get the driver name to pull up when I choose the car ID on the deliveries layout, but it doesn't work. I can use a drop down with the cars ID and driver's name shown second on the deliveries layout, but when I choose one, the driver's name field will not auto-populate on the deliveries layout. I'm sure I'm overlooking something here. Thanks in advance for any help.

First, why is DriverName in the Cars Table?

It seems a car can have several drivers, while a driver has only one car. If this is true, then selecting the CarID is not enough to determine who's driving it - but the opposite, i.e. selecting the driver and getting the car to populate automatically, should work fine.