Hi everyone,

I have this problem:
In our database we have 2 calculated fields: MapRef and APN. These fields are calculated using different algorithms for each town, e.g it could be town specific, but it also could be the same procedure for several different towns. Right now all algorithms reside in the big procedure file. We want to have table like this:
TownName MapRefProcedure APNProcedure.

Now there is a problem. If we keep all functions in one big procedure file and for each town just reference a FunctionName in MapRefProcedure field, how can we edit the code for this particular function? I mean, we should be able to hit Edit button and go directly to the Function for this specific town. Is it possible?

Another idea is to use a memo field with the actual code for each town and compile this code on the fly. In this case, obviously, we may have banch of other problems.

I prefer the first idea, but how can I go directly to the specific function in a long procedure file?

Hopefully, I explained my problem well.

Any help would be greatly appreciated.

Thanks in advance.