I'm anticipating something like this:

PERSONS
PersonID
Person fields...

REQUESTS
RequestID
RequestDescription
RequestType

RESPONSES
ResponseID
RequestID
PersonID
Response

I expect the Responses to be Numbers, Currency, or Yes/No, however, all
responses go in the same field, which can have only one data type. I have
set aside the RequestType field as some sort of flag to indicate the kind of
response expected for each request.

Question: Which data type should I use for the Response field? It seems
like Number would work, but an example I've seen used Text.

Bonus Question: Is there a preferred way (sample code?) to make use of the
RequestType to convert the Response into the correct value of the correct
type?

Thanks,
OldBlindPew