Hello Everyone,

Here is my scenario. I have a database just for all of my value lists. There are several different codes for each ministry at our church. I have broken all of them down for each ministry. There is a Primary Key for each ministry. Then there are sub value lists for each ministry. Everything works fine in browse moden when they are entering data into the main database however my value lists do not work in find mode.

I basically have a main database that has calculations with a constant value. One for each minstry. Then I have a relationship back to the codes database to build each unique value list for each ministry.

For some reason it is not working in find mode. Any suggestions?

Thanks in advance,

Adrian

Hi,

Change your constant calculations to global fields, and switch the relationship based on this global. I know someone who recently took me for a fool, but here's one major reason why I personally use globals instead of calculations for this kind of Dynamic inputs.

Thanks for your help. It worked great. I did however have to keep a relationship for each ministry seperate because these fields were sometimes on the same layout. I just added a SET FIELD step for each global field on my startup script.

Thanks,

Adrian