damon_albran Posted November 26, 2002 Share Posted November 26, 2002 Hello, I have a price history database related to a product database, that I've a portal showing the price history on the product master, and that portal is sorted by date, so most update price should always on top. The problem I facing is I want filemaker to compare the latest price and the second latest price (the 1st and the 2nd row of portal), I know how to get the latest price by calculation, but it seems no way to retrieve the price on second row. I know it could be done by script, but I hope it could be automatically based on calculation field. Please help! Thanks in advance! damon Link to comment Share on other sites More sharing options...
djgogi Posted November 26, 2002 Share Posted November 26, 2002 I will assume that the history for every selected product is not infinite (iow has not thousands of entries). So since you allready have established the relationship (based on product id, I suppose) the next step is to create an value list "priceHistory" based on this relationship as use only related values from field "dateToNum" (very important, the field is calculated with dateToNum=date, result number) show also PriceID (as second field), select sort on first field. The field PriceID should be an calculated kompound key like ID & " " Link to comment Share on other sites More sharing options...
djgogi Posted November 26, 2002 Share Posted November 26, 2002 Oops should be ID & " " & productID and not ID & " " Link to comment Share on other sites More sharing options...
damon_albran Posted November 27, 2002 Author Share Posted November 27, 2002 Dear Djukic. Thanks and I will try! Dmaon Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7963 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