Start a new topic

Referential integrity on a Reference selection in a Form

I have a field that has a reference selection on it(Special Brand).  The reference selection is filtered based on a user entry on another field on the form(Brand).  For example:

image

image


If the user makes a selection for Special brand the value is held in the field:

image


The issue I'm facing is, if the user changes the first field(used to filter the reference selection) Brand in this case, the second field in invalid it breaks the referential integrity.  See below:

image


image


But if I hit the dropdown...

image


Is there a way to check the Referential integrity of the Reference selection when the filter field(Brand) is changed?


Login to post a comment