**This section shows the three parts of the SQL statement (SELECT, FROM, WHERE), 
**when you load it into ManEx, they will all need to be on the same line (as in the second example).


SELECT mrplistview.part_no, mrpinvt.buyer_type, mrpact.reqqty, mrpact.reqdate, mrpact.prefavl 
FROM (mrplistview INNER JOIN mrpinvt ON mrplistview.uniq_key = mrpinvt.uniq_key) INNER JOIN mrpact 
	ON mrplistview.uniq_key = mrpact.uniq_key 
WHERE (((mrpinvt.buyer_type)="ONE"))



**Copy the line below, paste it into the trigger, and change "ONE" to the desired buyer

SELECT mrplistview.part_no, mrpinvt.buyer_type, mrpact.reqqty, mrpact.reqdate, mrpact.prefavl FROM (mrplistview INNER JOIN mrpinvt ON mrplistview.uniq_key = mrpinvt.uniq_key) INNER JOIN mrpact ON mrplistview.uniq_key = mrpact.uniq_key WHERE (((mrpinvt.buyer_type)="ONE"))