Hi
I have a main form named as" Certificate Details" which presents the table "CertificateDetails" and interested to pull the values from another table named as" QualityInspection" based on matching of three fields criteria.
CertificateDetails.InspectionDate =QualityInspection.InspectionDate
CertificateDetails.PDate = QualityInspection.PDate
CertificateDetails.Product = QualityInspection.Product
The data must be pulled from below fields of table "QualityInspection" and filled up in the fields of table "CertificateDetails":
Note: The fields name are same in the both tables.
AELength
AIDSpigot
AIDSocket
AODSpigot
AODSocket
AWTSpigot
AWTSocket
ADSocket
ASqEnds
ADvStraightness
Kindly advise the needful.