Auto Select from another table

[spearson]

I not very bright when it comes to access but here we go:

I have two tables which one has an error code and a solution column. In my other table I have a table to record trouble shooting. When I type in an error code, I want the solution to automatically pop up that coincides which that particular error code. I know this is probably easy but I do not know where to begin

 

[Jack Cowley]

In the table where you will put the Error Code you do not want to put in the Solution as well, just the Error Code. On your form where you will enter the error code I suggest you use a combo box that is based on the table of Error Codes so you can and easily select the Error Code you want. Bind the combo box to the ErrorCode field and it will be saved in the table. Any time you want to see the Solution you can do that with a query based on the two tables.

I hope that this makes sense to you.

Jack