Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

Hello everyone,

I swear I've seen this topic before but can't seem to find it now. If someone could point out a post or help me I would appreciate it. I have four tables,

Customer

Quote

Quote Item

Job

Quote Item has both a QuoteID and JobID. A job are items that were quoted that need to be processed. This so far has worked well. I can print a quote report for all items and then if it is a job, I can print anther report to process it.

What I'm can't seem to do is sum total Customer orders. I want to track a "capture" rate on Customer table. How many actual dollars am I getting from quoted dollars. I'd like to do this for each customer. I can sum Quoted dollars easily from an extended total field on Quote Item, but can't seem to sum only records that have a JobId.

Thanks for any help.

This topic is 6765 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
×
×
  • Create New...

Important Information

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