How do I handle this scenario.
I have a "Status" table which assigned StatusIDs to another table.
In my Edit form I have the Status ComboBox filtered to only show a few of those items. So 10% of my items are items NOT in this list...so when the edit form loads I get a YSOD because the items its trying to Two-way bind with isn't in the combo.
How should I handle this scenario?
I have a "Status" table which assigned StatusIDs to another table.
In my Edit form I have the Status ComboBox filtered to only show a few of those items. So 10% of my items are items NOT in this list...so when the edit form loads I get a YSOD because the items its trying to Two-way bind with isn't in the combo.
How should I handle this scenario?