Hello,
I was wondering if I could get some advice, only being new to access I am unsure on how to proceed.
I am creating a database that holds a the information an employee submits towards the job they are working on. Each job has three main unique points in can be identified on (the name, ID and CODE), and to make it easier for the employees I have created a separate table which holds all this information.
On the form that they will fill out, I have added a lookup, for the ID (which also shows the name and the code in the combo box.
I then have the name and code on the form so that when they choose the ID it fills out the other.
This all works fine.
only an employee sometimes may only hold one thing which helps to identify the site.
At the moment if you type the ID in the box, the lookup will find that job site. I want to be able to type a code or a name into this box and for it to show the relevent ID. (So that when I select it, it will put that information in the correct boxes. Is there a way to do this?
Thankyou
I was wondering if I could get some advice, only being new to access I am unsure on how to proceed.
I am creating a database that holds a the information an employee submits towards the job they are working on. Each job has three main unique points in can be identified on (the name, ID and CODE), and to make it easier for the employees I have created a separate table which holds all this information.
On the form that they will fill out, I have added a lookup, for the ID (which also shows the name and the code in the combo box.
I then have the name and code on the form so that when they choose the ID it fills out the other.
This all works fine.
only an employee sometimes may only hold one thing which helps to identify the site.
At the moment if you type the ID in the box, the lookup will find that job site. I want to be able to type a code or a name into this box and for it to show the relevent ID. (So that when I select it, it will put that information in the correct boxes. Is there a way to do this?
Thankyou
