LearnersPermit
Technical User
I have a database that manages our fleet of vehicles. This year I am trying to add a new feature. The ability to assign different coding to various sign outs of vehicles.
Users select the vehicle that they wish to use, then select their name from the list of users. As they make each of these choices several other boxes are filled in, for example the current mileage of the vehicle and their coding.
This year we found that people wanted to use various coding. When they wished to change the coding, I went into the users table and changed the coding. My results table held the coding for each borrow.
I have created a coding table which has a one to many link to the users table. Each user will have at least one coding in this table. I have tried several ideas for allowing the users to select their coding without success. I tried a combo box, list box and subform.
Suggestions would be appreciated.
Users select the vehicle that they wish to use, then select their name from the list of users. As they make each of these choices several other boxes are filled in, for example the current mileage of the vehicle and their coding.
This year we found that people wanted to use various coding. When they wished to change the coding, I went into the users table and changed the coding. My results table held the coding for each borrow.
I have created a coding table which has a one to many link to the users table. Each user will have at least one coding in this table. I have tried several ideas for allowing the users to select their coding without success. I tried a combo box, list box and subform.
Suggestions would be appreciated.
