different program different words

I have created a database with a table of questions and a table of
sections. Certain questions belong under certain sections. There are
about 240 questions for 2 programs where people analyze the responses
and give suggestions on improvements to processes.

The questions are identical for both programs except for about 6
different sets of words. One example question would be:

Program A: Does your Agency have a computer firewall?
Program B: Does your Brokerage have a computer firewall?

These word replacements would only be necessary for maybe a dozen questions.

I was wondering what the best approach would be?

I didn't think it would be very efficient to check every question and
replace the word if necessary as they are printed to the page.

Thanks,
Pasquale

Re: different program different words

>I have created a database with a table of questions and a table of
>sections. Certain questions belong under certain sections. There are about
>240 questions for 2 programs where people analyze the responses and give
>suggestions on improvements to processes.
>
> The questions are identical for both programs except for about 6 different
> sets of words. One example question would be:
>
> Program A: Does your Agency have a computer firewall?
> Program B: Does your Brokerage have a computer firewall?
>
> These word replacements would only be necessary for maybe a dozen
> questions.
>
> I was wondering what the best approach would be?
>
> I didn't think it would be very efficient to check every question and
> replace the word if necessary as they are printed to the page.

1 possibility would be to have a flag with thw question denoting wether a
replacement is needed in the question. Use an if stateme nt to check if the
flag is set, if it is then do the replace if not just use it as normal.

Re: different program different words

peter wrote:
>> I have created a database with a table of questions and a table of
>> sections. Certain questions belong under certain sections. There are about
>> 240 questions for 2 programs where people analyze the responses and give
>> suggestions on improvements to processes.
>>
>> The questions are identical for both programs except for about 6 different
>> sets of words. One example question would be:
>>
>> Program A: Does your Agency have a computer firewall?
>> Program B: Does your Brokerage have a computer firewall?
>>
>> These word replacements would only be necessary for maybe a dozen
>> questions.
>>
>> I was wondering what the best approach would be?
>>
>> I didn't think it would be very efficient to check every question and
>> replace the word if necessary as they are printed to the page.
>
> 1 possibility would be to have a flag with thw question denoting wether a
> replacement is needed in the question. Use an if stateme nt to check if the
> flag is set, if it is then do the replace if not just use it as normal.
>

This may be a simple question, but would an index be an option to flag
or would another column with say 0 or 1 as a flag be better?

Thanks,
Pasquale

Re: different program different words

> This may be a simple question, but would an index be an option to flag
> or would another column with say 0 or 1 as a flag be better?

i personally think a 1 or 0 type flag would be better