Yes, I could reconstruct the record amicably. Thanks for your input. I used following generic code to get the data in each form using MassUpdate for just one record.
var vList as String
var n as Int
var vName as String
var vCount as Int
var vReturnValue as String
var vString as String
var vStr as String
If @AskUser("Have you placed the BACK UP OF " + @Application + ".db" + " into 'c:\backup' folder?", "", "") then
{
Vlist = @stringArrayElementList( )
vCount = @CountStringArray (vList)
//WriteLn (VList)
n = 1
While n <= vCount
{
vStr = @AccessStringArray (vList, n)
SetThisElement ( vStr)
If @ElementBoundToType (ThisElement) >=3 and @ElementBoundToType (ThisElement) <=6 then
{
If vString = "" then
{
vString = vStr
}
Else
{
vString = vString + ";" + vStr
}
}
n = n + 1
}
UnsetThisElement ( )
//WriteLN (vString)
vReturnValue = @XLookupSourceList("C:\backup\" + @Application + ".db", RecNumber, @Layout + "!RecNumber", vString)
//WriteLN (vReturnValue)
vCount = @CountStringArray (vString)
n =1
While n <= vCount
{
vName = @AccessStringArray (vString, n)
SetThisElement ( vName)
ThisElement = @AccessStringArray (vReturnValue, n)
n = n + 1
}
UnsetThisElement ( )
@MSGBOX ("Hit F10 to save to save the record if everything is as expected", "If not, just hit escape and troubleshoot", "" )
}
Else
{
@MSGBox ("Please put backup of " + @Application + ".db " + "into c:\backup folder first", "", "" )
}
Since the code is generic, I could use the same code for all the forms concerned. It was not difficult. However, I still hope to have the command or function that could work on database instead of form, that way the whole process can be completed with a single stroke.