Auto Selection from a Table

[spearson]

Ok guys be gentle, this is probably a real basic question but here goes!

I want information from one table to automatically pop up in another table. I have a table with error code, error description, solution, etc. In the other table I will record trouble shooting calls. When I key in the error code, I want the solution from the ErrorTable to automatically show up. Can I do this in tables and how?

 

[Jack Cowley]

Hmmm. I thought I answered this question but maybe not... Anyway, you cannot do this in a table but in a form. You can use a combo box to get the error code and save it in the table, but you do not want to save the 'solution' as well as that goes against database normalization. You do not want redundant information in a table since it is available somewhere else...

Jack