Thanks Seth

I've been doing a bit more reading and have now discovered that for transactional replication to work every table replicated has to have a unique ID column, problem is...