I've been working on this database for a while and I'm starting to "confuse" myself. What it is is a database to have a registry of pastors for a conference of church's. I will have about 200 pastors and I want to link them to a church. The issue I'm having is how to change the church a pastor is linked to. In other words a pastor can be moved from church to church and I don't want to lose the information we already have for that church. Currently I have limited fields int he church table until I get it working properly.