Christine Jackson
Registered User.
- Local time
- Today, 03:18
- Joined
- Mar 21, 2008
- Messages
- 15
I have a database with a number of tables, all linked. In the forms I would like to make a combo box to pull through information from another of the tables (I have also created a query linking the info if that helps), but it only pulls through the wrong info.
To try and explain in Table 1 i have a load of vehicle details, such as registration, date regisetered, make, model, co2 emissions and list price. In Table 2 i have employee no, address etc.
In a third table I have P11d information, i.e. date employee got the vehicle, its registration, etc. In this 3rd table a number of caluculations are also done. I have created a form for this table as the information within this table can change quite frequently. What i would like to be able to do is have a combo box so that when the registration is selected it inputs the list price.
I have selected the combo box that pulls values from another table or query. I have then selected the table I want the informationed pulled from (ie. table 1) and the information i want pulled through, i.e. reg and list price. I have then sorted by Reg in Ascending order, and then un-ticked the Hide key column box. I have un-ticked this as i need to be able to see the registration number to ensure that the correct info is being pulled through. I have then selected the Reg no as the field that uniquely identifies the row. Finally i have left the tick in the remember the value for later use.
When I go back onto the view, I can select the appropriate reg from the drop down list, but it pulls through the registration and not the list price.
I know that if I leave the Hide Key column box ticked it pulls through the list price, but i have no way of knowing if its the correct figure associated with that registration.
Anyone any idea what I'm doing wrong.
To try and explain in Table 1 i have a load of vehicle details, such as registration, date regisetered, make, model, co2 emissions and list price. In Table 2 i have employee no, address etc.
In a third table I have P11d information, i.e. date employee got the vehicle, its registration, etc. In this 3rd table a number of caluculations are also done. I have created a form for this table as the information within this table can change quite frequently. What i would like to be able to do is have a combo box so that when the registration is selected it inputs the list price.
I have selected the combo box that pulls values from another table or query. I have then selected the table I want the informationed pulled from (ie. table 1) and the information i want pulled through, i.e. reg and list price. I have then sorted by Reg in Ascending order, and then un-ticked the Hide key column box. I have un-ticked this as i need to be able to see the registration number to ensure that the correct info is being pulled through. I have then selected the Reg no as the field that uniquely identifies the row. Finally i have left the tick in the remember the value for later use.
When I go back onto the view, I can select the appropriate reg from the drop down list, but it pulls through the registration and not the list price.
I know that if I leave the Hide Key column box ticked it pulls through the list price, but i have no way of knowing if its the correct figure associated with that registration.
Anyone any idea what I'm doing wrong.
