any one help in using combo box

[jensonchandy]

i'm using access 2000
in the database i've two tables
one employee details...
another jobtitle

the employee details includes fields from jobtitles too
when i select the the job code from the combo box,i need the jobtitle in a text box.the job code is selecting from the jobtitle table and accessing using query.but i'm not able to get the jobtitle in the text box using the same query
plz help me

regards
jenson

 

[neileg]

Is this what you mean?

 

[jensonchandy]

help needed

now i made some changes in the table and forms
in the table i add job title also

in the form when jobtitle id combo should contain the id and should be stored in the jobtitleid. when i select the id the corresponding jobtitle should be displayed in the textbox and should be saved in the database
regards
jenson

 

[neileg]

No, no, no, you do not store the job title in the employees table. Access is a relational database and you do not store the same data in two places. As you can see from the form I designed that the data is displayed exactly as required.

I can’t help on the new text box on the form because I don’t know what this is meant to do.

 

[jensonchandy]

ok i agreed with u and i had removed it from the table
and the id is getting stored in the table.

now what i need is using this i'm creating a report...in the report it's sorting according to the employee .in the details section i need the employee details and the jobtitle details
form the employee details i will get the jobtitle id . but how to display the
jobtitle in the report

regards
jenson

 

[neileg]

Create a query that joins the two datasets and base your report on that. See the attached.