>>Hi!
>>
>>We have added some new fields to tables.
>>In reports we combine 3 tables into 1 table and print it on the report.
>>
>>But now there are too many fields in the table (over 254)
>>is there some easy way to get around this limit.
>Tim,
>
>Yeah, use two tables for the report with 127 fields in each. You can set up a one to one relationship between the two tables.

Since they create these tables for each report, they can guarantee record ordering. This allows them to save a column per table by indexing and setting relation on recno().