Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
195
"Must have related record" error even with Null in UltraCombo
posted

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?

  • 2197
    posted

    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?