In FormA I have a lookup field (current type) which is related to FormB. When I select a product (current type) on FormA, and it is related to (fixture code) in FormB, i would like several other fields with data stored in FormB to auto populate in FormA.
Any insights much appreciated!!