Ok, I have a non-normal listbox environment. I have a form with 9 lists and 6 of them are paired, like a Y / N / option set.

They are generated in a BO like this:
public DataSet GetSAE()
{
return this.GetDataSet("SELECT distinct ap_SAEtyp sae, '0' as ap_key from dbo.depappl order by 1");
}

I will get 3 transactions "P", "T", " ". Perfect.

When I try to use them in a ListBox I bomb out. A reference to a key is the WEB error I get.

I see the key in that Select statement identical to the key listed in the BO.
public SAE()
{
this.TableName = "depappl";
this.PrimaryKey = "ap_key";
}
public DataSet GetSAE()
{
return this.GetDataSet("SELECT distinct ap_SAEtyp sae, '0' as ap_key from dbo.depappl order by 1");
}

Anybody using Dropdowns in a maner like this, vs Key,Show column and you baind the key to the reciving table?

__Stephen Russell
>>
"Simplicity is the ultimate sophistication."

Leonardo da Vinci

>> My old crummy site.