<p>I have two Tables.</p>

<p>Order - With Columns OrderID, OrderStatusID<br />
OrderStatus - With Columns OrderStatusID, Description</p>

<p>I have an Order Object which calls to the database and fills its properties for use in my code.  Right now I have access to Order.OrderStatusID, but in my application I really need access to the "Description" field.</p>

<p>How do you handle this elegantly with good OO design?</p>

You can use a SQL select statement with a Join to the OrderStatus table, and include the columns yo want from each table ...
```
```
Select O.OrderId, O.OrderStatusId, S.Descriptiuon
From Order O
    Join OrderStatus S 
        On S.OrderStatusId = O.OrderStatusId
Where OrderId = 23 -- or whatever
```
```