I have a related field Entity one-to-many in a Client table using Access.
If the Entity combo is not touched and is empty, the Client record saves fine.
If the Entity combo is edited but ultimately left blank, I get "related record is required in table entity" and save fails with a runtime error.
If Entity is Null, that should be an acceptable value to save. Only if the field contains a value not in the Entity table or empty string "" should this error occur.
AllowNull is set to true. The combo clearly has a value of Null when empty because Null Text appears if I enter a value for Null Text.
What is going on!? How do I get past this?
Hello. Is your combo free standing on the form itself or is it an editor in a WinGrid cell? Are you using the UltraCombo or the UltraComboEdito? Also, what version of Net Advantage are you using?