I have several tables that have common data in fields 1-3. The rest of the fields have yes/no in the values.

I want to copy the field name into a text field and the yes/no into another field. This routine needs to work for any number of columns.

Here is what I have:

client name srvdate test1 test2 test3 ...
123456 Doe, J 12/12/2006 no no no

I want to make multiple records in the receiving table for each client

client name srvdate test result


123456 Doe, J 12/12/2006 "test1" no
123456 Doe, J 12/12/2006 "test2" no
123456 Doe, J 12/12/2006 "test3" no

Does anyone have a source for existing code for this or a suggestion as to how I can build this quickly?

Thanks.