Lookup Column; storing information in another field

[Gabriel2012]

Hello, I am dealing with two fields; "Error Category" and "Error ID". Each cooresponding error ID has a cooresponding error category (They are matched in up a sepearate table). In my errors table, I have created a lookup field in the "Error Category", which allows a used to select the error category from a drop down list. I would than like for the appropriate error ID to populate into the "Error ID" field based on the error category that is selected. How is this accomplished? Thank you

[June7]

Set the ControlSource property to the destination field.
Set the BoundColumn property to the column with the Error ID.
Review http://datapigtechnologies.com/flash...combobox3.html

How long are category values? Might just save them instead of the ID. Less complication in queries.
Review http://access.mvps.org/access/lookupfields.htm

BTW, advise no spaces, special characters, punctuation (underscore is exception) in names.

[Gabriel2012]

Thank you, that worked in allowing me to store the Error ID in the Error ID field, when selecting the category, however now that the Category field is bound to the error ID field the category description is no longer stored in the "Category Description" field. I need to select the category description from the field in the form, have the linked error ID stored into the Error ID field and have the category description stored in the category description field on the form.

[June7]

That sounds like duplication of data. If you have the Error ID saved why would you also save the category? Retrieve the category in query that joins the related tables.

Unless I misunderstand what you are doing. Do you want cascading (dependent) comboboxes? Review http://datapigtechnologies.com/flash...combobox2.html

[Gabriel2012]

Good point, this has solved my issue, thank you.