Purchasing is going thru the inventory listing updating the ROHS fields.  In many cases, some vendors
have over 1,000 products/parts in our inventory, and we would want to change all those parts for that vendor from N to Y.  
 
Is there any way where if we can say "if Vendor name = ABC, then for ROHS change from N to Y"
easily enough?  It would save a lot of time.  

You could do it as a SQL command at the Pervasive Control Center.  The RoHS value is position 4 in a 4 character field so I will have to lookup the syntax for updating a substring of a field.  I will email it to you.