Here is my trouble. We deal with Youth Pastors of Churches and churches. I want to be able to add a new person and a new church to our database when they call in and request information at the same time. The problem is that I cannot keep the personal info and the church info in the same table because youth pastors frequently change churches.

Here is my question. How can I make a relationship between a church and a youth pastor so I can enter them at the same time, yet be able to separate them later and join them to a new church?

I really need so direction. I am lost. Thanks so much!!!

Drew

Global Youth Ministry

Drew,

Here's something that might work from a novice. I'll bet there's an easier way to do with with FM7 or FM8 but I haven't learned it yet

Global_Youth_Ministry.fp7.zip

I imagine there are many churches and many Youth Pastors and that some churches have more than one Youth Pastor and some Youth Pastors go to more than one church?

You can relate them by Church Name. The input page should be in the Youth Pastor table. Have a drop menu, or a series of radio buttons or, if YPs go to more than one church, use checkboxes. Then have a portal for the church information. Once you have selected the church, if it already was in your church table, all the information will appear in the portal. If it is a new church, just start filling in the information in the first blank portal row (probably the top one). A new church record will be created automatically.

I have sent along a little model

Good luck

Jake Sterling

Church_YP.fp7.zip

Edited March 13, 200619 yr by Guest

Awesome, I will give these a try. Thanks so much!!!

Drew