I need to allow users to select subcategories for a record based on key
values. So I imagine a lookup combo with the possible values to select. But
sometimes the value needs to be NULL or not selected and the key is
inserted/updated as NULL rather than a value from the lookup table. The
lookup table will change depending on the value of another lookup so it's
not possible or desirable to add NULLs to all the possible subcategories.
Is there an elegant way to achieve this? anyone any ideas? The lookup
dataset would need a null value as well as all the other possible values
each time it opens with the null valueat the top of the list.. Is building
the itemslist manually the only way? or is the some workaround for a
dataaware control?
thanks
Alan