Hey all,

I upgraded from 1.2 to 2.5 and I've found a small upgrade bug.

I have a payment screen where is store a file number, but not the customer's address, salesman or staff member handling their file.  I have my payment screen do a xlookupsourcelist pull the current data from our sales database and our work database.

The problem I have is the xlookupsourcelist is pulling the address on form entry, but not the staff member data.  And it was working fine in 1.2.  My code is below:

Help?

if PmtDBNo >0 THEN
{
	vDBData = (@Xlookupsourcelist(@FN, PmtDBNo, "DR Screen!DBID", "DBCltNo;DBName;DBAdd1;DBAdd2;DBCity;DBProv;DBPCod;DBRef#;DBColl#;DBTrac#;DBLgl#;DBListed;"))
	PmtCltNo = @AccessStringArray(vDBData,1)
	DBName = @AccessStringArray(vDBData,2)
	DBAdd = @AccessstringArray(vDBData,3)
	DBAdd2 = @AccessStringArray(vDBData,4)
	DBCity = @AccessStringArray(vDBData,5)
	DBProv = @AccessStringArray(vDBData,6)
	DBPCod = @AccessStringArray(vDBData,7)
	PmtRef = @AccessStringArray(vDBData,8)

	PmtColl = @AccessStringArray(vDBData,9)
	PmtTrace = @AccessStringArray(vDBData,10)
	PmtLgl = @AccessStringArray(vDBData,11)
	DBListed = @AccessStringArray(vDBData,12)

	vSalesData = (@xlookupsourcelist(@FN, PmtCltNo, "Sales Screen!CltNo", "CltName;CltSales;CltIntDeferred;CltIntRate"))

	PmtClt = @AccessStringArray(vSalesData,1)
	PmtSales = @AccessStringArray(vSalesData,2)
}