Hi Dean,
The only way I can think of doing this is to have two instances of the same drop-down, each populating from the different data sources, and then simply conditionally hide the one you don't want to show. Be sure to clear the entry in the drop-down whenever you switch, otherwise you might get bad input.
Matt Faus / Microsoft InfoPath MVPQdabra® Software / Streamline data gathering to turn process into knowledge