Reporting from multiple files

[ASNL]

I have 3 diffrent files. A customer file, A service file and accounting file. Customer file contains the info and custom ID for each person who is going to be in the report. The Service file is for tracking all work done at each customer, and an accounting file for recording payments and tracking how many hours our service plan customers have left. The data entered into both contain the customers uniqueID found in the main customers file.

I would like to create a report in the customers file for individuals and perhaps groups of individuals based on there customerID, With sub data from both the service and accounting files. I can get it to show the last record entered in both files under each CustomerID, but it won't show all the records. Is doing full reports using data from multiple files even possible? TIA.

[Afishinado]

Please let me know when you get a reply,I'm asking the very same question! I have a file for customers, a file with inventory, and a order file, I'd love to make an order file that can pull 'found items' from inventory and from customers to just make one record. I know FM can do it, I just haven't figured out how!

Thanks

Mike

[email protected]

[danjacoby]

Seems to me that creating the proper relationships/portals ought to do the trick.

If you're in the Customer file, you should have only one record per customer; with portals to the various servicings and billings you should be able to print a complete report.

One caveat, printing from portals has always been quirky, but I have faith in you.

[ASNL]

Unfortunatly Portals are too limiting, It needs to be in an actual report. The solution I have currently combines the accounting and service files into the same file. Each having its own layout and an Identifyer tag that autoenters depending on which layout your on (accounting or Service). This allows me to have all the info combined into the same file for reporting. But its not real elegant. I figured multi-file reports would be a must for an esablished Relational DB program like filemaker. Apparantly not.