SQL Problem on a form- Combo Box Communication

[MajorChaos]

all right. here gos:

I have a form, on that form is a combo box that is getting its data from another table. 1.(Profile Form), 2.(Combo Box priorityID) 3. (priorityTB Table, field 1 priorityID, field 2 priority---data in field 2--High, medium, low).

I have the combo box retrieving data just fine, on the profile form the data is just how it needs to be, I can select data move on to a new record..etc. my problem is when I go to do a report, or look at the profile table, the priority ID field shows the auto number instead of the data it relates to.

how do I fix this so that my reports/tables give me the data instead of the autonumber?

Thanks

 

[aojonesoa]

For the reports, you can run them from a query that has the table with the autonumber field, and the related table that has the other information. Then, in the report, use the field from the query that comes from the related table.

 

[MajorChaos]

thanks aojonesoa

I figured it out an hour after I posted. I did not have the columns set correctly in the propertys for the combo box. once I changed the defalt (1) to (2) and then told access not to display the first one (0";2&quot it worked great! sometimes the answer is right in front of us and we just cant see it. thanks for your response.