How do I navigate to a particular record in a table variable?
I have a couple of tables that are related to one another and I need to select the particular records depending on the PK that is selected from the parent table.
For example:
Patient table has MRN, NameFirst, NameLast ...
Address table has MRN, AddressID, Address1 ...
There is a data-driven loop for the Patient table
There is a while loop for the Address table where Address.MRN = Patient.MRN
When I choose to start at a particular record in the Patient table, say record 3 which happens to be MRN = 3.
The code for the While loop of the Address table is not recognized because the Address.MRN = 1, and not MRN = 3 that it needs to be.
How do I force the Address table to start at Address.MRN = 3 record?
I tried Call Object Method and looked at the Addres.Iteration, Value [Set], Address.MRN = Variable.MRN (which has the value of the current MRN working on).
This didn't work.