> Is there a limit to the max number of fields a db can have?
> Im currently have to create a report with a break down of 7 items, per
> month with claims per Item adding in totals, percentages and such. approx 20
> field per month, showing 1 year of information. I was going to try and do
> this with relationships and portals but i dont think the numbers would be
> accurate, a three month contract purchased in january expiring in march with
> no claims just gets deleted , using rel. and portals , january total sales
> will change.
> Im sure others have run across similiar situations to this, and how to
> approach it.
There is no set limit to the numbers of fields. However, trying to
create a cross-tab system in FM is often fraught with problems. May I
ask if you've considered subsummary reports and whether they might
provide the required information even if it doesn't present *exactly*
like a spreadsheet cross-tab kind of printout?
Another alternative is to keep the information in FM, and create the
reports in Excel. FM 5.5 plays excellently with Excel, even to the
extent of being able to create a chart in Excel and update it with live
data from FM using Publishing.
Creating 20 new fields (or is that 20 x 7?) per month, is, I guarantee
you, the wrong way to structure your file.
Lynn Allen Allen & Allen Semiotics
FSA Associate Filemaker Consulting & Training