where can I find relationship short term effects and long term effects? please

The sites I posted about the short and long term effects of drinking alcohol should help you. Just apply the effects to relationships.

This one is more specific.

http://www.infoscotland.com/alcohol/CCC_FirstPage.jsp