I am so new to this, I'm a bit lost.  I have an application with two forms accessed by two different groups of people.

 

The first group will use the first form (form A) to enter a request for information related to a specific numbered asset (Asset_Name).  The second group is logging row upon row of data related to various assets numbers in a second form (form B); they have two fields they use to capture the asset information.  The first is a single line text field where the primary asset number is entered; the second is a multiline text field where up to several secondary associated asset numbers may be listed.

 

I want to alert the second group (using form B) when the first group has requested information related to an asset the second group just entered information on either in the first primary asset field or the second, associated assets field.

 

I have figured out how to trigger an alert when they enter data in the first field, but figuring out how to trigger an alert when they enter several asset numbers in the second field multiline text field is confusing.

 

I've tried to figure out something when the second field multiline text field "contains" the input from the Asset_Name field, but no luck.

 

Any takers on helping a newbie in the middle of Oklahoma USA figure this out?