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)
}