Hi, I have two forms I enter info into one form (Suppliers) and use sc_lookup to find the SupplierID (PK) then I insert that SupplierID into another table (the destination field is also called SupplierID but is not the PK Everything works fine except I also want to use sc_redir to go to the second form and open it at the newly entered record. I’m using sc_redir(VehicleDetails,SupplierID = {SupplierID}); but it’s opening at the first record instead of the last. I hope this makes sense…Any assistance gladly received. Thanks
Solved using variable:)