Workflows & Lookup fields

Workflows & Lookup fields

Is it possible to have a workflow that changes a lookup field on an account form to assign the Contact just created/edited for an account that has the role of manager as the value for the lookup field rather than the user having to select a contact from the account record? 

Mind you I have just realised that wouldn't probably work as you might have multiple contacts created that had manager set as the role. Stumped now.