I want to display Job Numbers with their Test price totals in a portal on an Invoice file. An Invoice can have many Job Numbers and a Job Number can have many Tests. So far I can get it to show the Job Numbers (duplicated as many times as there are Tests for that Job Number) and the Price for each test listed beside it.

How do I make it list the Job Number only once, and the total for all the Tests in that Job beside it?

I think the organization of your three files is:

Invoices --> Jobs --> Tests

If you wan to see a total of the test costs in the portal displaying Jobs in the Invoice file you need to create a calculation field in Jobs that uses a relationship from Jobs to Tests to add up all the appropriate tests for a job.

TestCost (calculation, number) = Sum (RelWithTests::Cost)

This field can be displayed in the portal in Invoices, as can any field from Jobs.

-bd

[ October 04, 2001: Message edited by: LiveOak ]