Hi Brett,

Thank you very much.
Sorry for the delay, there were some issues finding the proper solution.
It is really a little bit tricky.

In order to sort the data in the FK dropdown you need to do the following.

Here is example with the ctrlCategoryID SmartDBControl:
...
<smartDBforms:SmartDBControl Field="CategoryID" ID="ctrlCategoryID" 
runat="server" ondatabinding="ctrlCategoryID_DataBinding" />
...

/////////////////////////////////
// DROPDOWN SORTING EXAMPLE
protected void ctrlCategoryID_DataBinding(object sender, EventArgs e)
{
    DropDownList dropDownValue = 
		((SmartDBControl)sender).FindControl("DropDownValue") as DropDownList;
     // Dropdown is availailable only in Edit mode. Check if exist.
	if (dropDownValue != null)
		// Register for the DataBinding event which will trigger just 
		//before the dropdown is filled with data
		dropDownValue.DataBinding += new EventHandler(dropDownValue_DataBinding);
    
}
    
// This will fire after the standard databinding.
void dropDownValue_DataBinding(object sender, EventArgs e)
{
    // Get the DropDown data table
    System.Data.DataView dataView = ((DataBindItem)this.Page.GetDataItem()).FKParentTable;
    // Sort the table on the caption column
    dataView.Sort = "FK_CaptionColumn";
    //Override the .DataSource property with the sorted data
    ((DropDownList)sender).DataSource = dataView;
}
...


If you have any other questions, we will be more than happy to help you.
Best wishes,
Adillis Support
Adillis - IT solutions http://adillis.com