the attached code snippet works fine as is.
what I want to understand, relating to this code, how do I link 2 sql tables as follows:
[CallBackItem_ID] is an integer field, refering to a Primary Field called: [CallBackItem_ID] in a table called: CallBackItems
What I am looking to have returned is not the [CallBackItem_ID] number as this is a reference to another table, but from that other table, CallBackItems the CallBackItemDesc field (which has an text description, which is more meaningful to user than a number). CallBackItems table is used to propagate a drop down list.
What do I need to add to this code in order for this to happen please?
Time and efforts with the enqury are much apprieated.
<asp:SqlDataSource ID="SqlDataSource_ProspectCallbackHistory" runat="server" ConnectionString="<%$ ConnectionStrings:FORTUNEConnectionString %>"
SelectCommand="SELECT [CallBackItem_ID], [DateTimeStamp], [DataEntryUser] FROM [CallBackProspectCallHistory] WHERE ([MasterAccount_ID] = @MasterAccount_ID) ORDER BY [DateTimeStamp] DESC">
<asp:SessionParameter Name="MasterAccount_ID" SessionField="sessionMasterAccount"