I was wondering if anyone could help me? Basically, I've set up a small database for a car hire company, and I have nearly finished it. However, something that I need to do, and am really not sure how to, is, when you select a car from a drop-down box, e.g. Ford Fiesta, the category that the car belongs to is automatically put into the CarCategory text box.
There are five categories - A, B, C, D and E and, for example, you choose the car 'Ford Fiesta' from the drop-down menu, the category 'A' is automatically put into the CarCategory text box (as the Ford Fiesta belongs to category A).
Does anyone know how to achieve this? I would be extremely grateful for any help!
At the moment, all I have done is to make two fields in my table, the first called CarMake and the second called CarCategory, as I wasn't sure at all how to go about this and I have very little to no VB experience!