Jump to content
Sign in to follow this  

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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