When you use the database relation field in Pages it will behave a bit weird. So thanks to Opentype over at Invisioncommunity forums this was demystified.
So, if you in database 1 add a database relation field to database 2, then the output in database 1 will come from the template basicrelationship. If you activate cross reference on that field then the output in database 2 will not use the template basicrelationship for some reason. Instead you will need to add the output format in the template itself.