result of select statement as TOOLTIP

[hudo]

Hello,

I got a table "table_content"
ID STATUS
1234 1
1235 1
1236 12
1237 65
1238 1
1239 13


and another table "table_error"
STATUS Description
1 Everything ok
2 IO-ERROR
12 TYPE-ERROR
13 NO CONNECTION
65 NO VALID DATA

I display the table_content in a form and by going with the mouse over a STATUS field (ie: STATUS = 12) the corresponding entry(ies) from a select
(here: select description from table_error where status = 12) should appear just like the TOOLTIP (here: TYPE-ERROR).

[skhanal]

Join two tables in a stored procedure.

select description
from table_error
join table_content
on table_error.status=table_content.status
where table_content.status=@parameter


pass 12 as @parameter.