ASP.NET

MasterTable [Columns: MasterTableID (PK), Name, ReferenceID (FK)(Nullable)]<br />
ReferenceTable [Columns: ReferenceID (PK), Reference]<br />

<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False">
<Fields>
    <asp:BoundField DataField="MasterTableID" HeaderText="MasterTableID"/>
    <asp:BoundField DataField="Name" HeaderText="Name"/>
    <asp:TemplateField HeaderText="Reference" SortExpression="Reference">
        <EditItemTemplate>
            <asp:DropDownList ID="DropDownList_Reference" runat="server" 
                DataSourceID="ObjectDataSource_ReferenceTable" DataTextField="Reference" 
                DataValueField="ReferenceID" SelectedValue='<%# Bind("ReferenceID") %>'>
            </asp:DropDownList>
        </EditItemTemplate>
        <ItemTemplate>
            <asp:Label ID="LabelReference" runat="server" 
                Text='<%# Bind("Reference") %>'></asp:Label>
        </ItemTemplate>
    </asp:TemplateField>
    <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
</Fields>
</asp:DetailsView>

Select Queries: 
Select MasterTable.*, ReferenceTable.Reference 
From MasterTable INNER JOIN
ReferenceTable ON MasterTable.ReferenceID = ReferenceTable.ReferenceID
Select * from ReferenceTable