My first suggestion would be that maybe the database design could be improved. If there are tables with common fields then possibly the common data should be moved to a separate table, or perhaps even the two original tables should be merged. It is a nightmare trying to keep tables with common data in sync.
Colin