Jump to content

Grouping In Portals


Cat8
 Share

This topic is 7319 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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 ]

Link to comment
Share on other sites

This topic is 7319 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.