Ed Wagner (2/5/2016)

---

Sean Lange (2/5/2016)

---

Stix83 (2/5/2016)

---

I have a table that has fields Code and Description

EG:

Code | Description

L40.2 | Sinusitis

I want to know if I can do this with a trigger

If I select the code, I want the description to auto populate in the next row beneath the code entry.

Very new at this Trigger functionality but willing to learn

No. That is not at all how triggers in sql work. A trigger fires when Update, Insert or Delete happens. They also cannot return data. What you need is an event in your application that fires on ValueChanged of your combobox and runs a query to get the new set of values for your application. This has nothing to do with triggers in sql server.

Of, if you're using .NET, the SelectedIndexChanged event will be the one you want.