Function to check if value exists in subform table.
How to check table row exists
In this example, we going to check either value B00001 in column Brand is exist or not in table Product List.
Create a new behavior. Put the appropriate caption. Click Action wizard.
Click Create an action.
Click Other Scribe Functions.
Select Check If Value Exists in Subform Row in Other Scribe Functions dropdown. Click OK.
Click Save changes.
Click View code. Change table field name, subform column name and comparison value accordingly. System will display a message if value exist. Click Check Syntax, if no error then click Save and close.
Click Create now.
Example how it look in the form:
