We can currently associate a custom object with an opportunity but that opportunity would have to be created elsewhere. It would be create to be able to create an opportunity right from a custom object workflow and associate them together.