Cat8 Posted October 5, 2001 Share Posted October 5, 2001 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 More sharing options...
LiveOak Posted October 5, 2001 Share Posted October 5, 2001 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 More sharing options...
Recommended Posts
This topic is 8238 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 accountSign in
Already have an account? Sign in here.
Sign In Now