Jump to content
Sign in to follow this  
briandye

Help with a calculation anyone?

Recommended Posts

Could anyone be so kind to point me in the right direction, here is what I am looking to do:

I have a table called factoryPricing I also have a table called Inventory. These tables are related together by a common field ProductID. The factoryPricing table contains quotes received for a product in inventory from a factory. There may be multiple quotes from a factory on a single item in Inventory.

I have a field in Inventory table called Cost that I would like to pull from a field called QuotedPrice from the record related to that product in the . However I would only like it to pull the most recent quoted price. I have a auto filling field in factoryPricing called QuoteID so I guess I need something along the lines of

If ProductID match with quote fill field with quotedPrice from the record with the highest number in QuoteID.... Just not sure how to form this expression in FM.... any help would be MUCH appreciated.

Share this post


Link to post
Share on other sites

I can't seam to get it to work :)-(

I tried

Last ( relationship::field )

the field did not fill. I am already sorting my portal, and the most recent price quote is at the top of the list. However I am looking to pull the field quotedPrice from the most recent Quote for the specific product. I am using a field QuoteID, I could pick from the most recent (greatest value of QuoteID for the relationship to that product, pulling the quotedPrice from this record and putting it in a field called COST in a different table - Inventory). Any more advice?

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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