Hello all,

I hope this will make sense. I have a Purchase DB with a notes field that I can create new notes for certain purchases. What I would like to do is show the last note inputed on a webpage if possible.

Here's the break down. The Purchase DB is part of a Software DB they share a relationship, and on the Software DB I have a portal to the Purchase database so when I purshase new things for a piece of software such as a renewal of a support agreement, the Purchase DB logs the date and the note I typed in. I already have a CDML page displaying th Software part, but I want the last log of the Purchase to display as well.

Again I hope this make sense.

thanks,

Jay

You could use a Portal which is sorted in descending order on RecordID! The [FMP-Portal] tags would then display the most recent record as the first one.

Good Luck.

Garry

Forgive me for asking, but how can I do that? I am fairly new to FM, if I right click the portal in layout view I do not have any options for that.

Thanks,

Jay

Jay:

Choose your sort order for the portal in the relationship, so go to Define Relationships... and select your relationship. There's a sort order checkbox and a specify button to pick your order.

-Stanley