I think every thing is ok but only the perform find is the problem.
So plz do one thing after moving to the Table1 Layout
Go to layout["Table1" (Table1)] after this step dont pause in find mode only
Enter find mode()
I thing this will solv eur problem if not then just go through the below step
But always keep in mind don't pause while in FIND MODE script step.
Another thing why pause/Resume script step is used more no of times this is not good ok.
Put all the condition within the Perform Find script
Go to layout["Table1" (Table1)]
Entar find mode
perform Find/Replace(all condition to find the record)
if(Get Found count>1)
Enter Browse Mode
set Field[Table1::Current Record Id;Table1::Record Id]
New record Request
While this now works. It could be simplified a lot. Unless there is another use for it apart from this script, you don't need a second table at all and your users could enter their data directly into the global fields instead of using a script to copy the data from the other fields in table 2.
Your posted script also shows Perform Find/Replace when it should show Perform Find, but perhaps you have already spotted and corrected that step.
Very Good point! Thanks. I appreciate reading your very insightful posts on the board. Your suggestion would simply require another Layout rather than another table, and the Data Entry Layout would use the global Named Fields. I will make that change and try it out.