Fetching information from existing record when populating form

Fetching information from existing record when populating form

We have 3 forms:
Form A (has multiple existing records)
Form B
Form C

When Form B is submitted, we want it to automatically open Form C and then:
1. Using a field in the submitted Form B, find matching/existing record in Form A
2. Insert information from record found in Form A into Form C

Would I use "Fetch Record" or "Get Record" for this type of action? I am getting stuck when trying to get information from Form A to be inserted into Form C...

Thanks for your help!

In this example below, I was able to get Form C to be populated with information from Form B. My issue is when I start trying to get information from Form A's records...

  2. //When Form B is Submitted, populate Form C field with information from Form B:

  4. if(What_Do_You_Want_To_Do == "Add a new asset")
  5. {
  6. openUrl("#Form:Form_Asset?Barcode_QR_Code=" + input.Scan + "&Status=Active","same window","height=<height>,width=<width>");
  7. }