Multiple fields same data

[Dave_Smith_(Guest)]

I have run across a problem that I am stumped by. I have a table in an accounting program that I cannot change where the program stores similar data in multiple fields in the same table. This is a payroll file. It has three fields that can contain three different state tax codes. There are also three different state tax amounts as well. I need to report on the state taxes but the data for any give state could be in field1, field2, or field3 for any given record. Normally I would create a new table creating new records, one for each of the three fields. This is not an option since I am inside the program when R & R runs.____Does any one have any ideas short of creating 50 total fields, which would be one for each state?__

[kfleming]

You could perhaps create a state.dbf with one record for each state and then build 3 scan relations to the table, one for each field.__With V10 you can build indexes on the fly to make this happen.__You would have a reasonably complex multiple scan table structure but could avoid the need for 50 separate computations.____Kathleen__R&R Support