Related records script?

[flapjacks]

Can anyone point me in the right direction to learn about the related records script step? I have an invoice table an invoice detail table. I would like to be able to view all products ever purchased by a customer but only the last date it was purchased.

Thanks much.

John

[Søren Dyhr]

One way to handle it is like the attached template does, although I've made a portal showing all the matches, but by sorting on the itemlineID backwards will the newest show up first!

I've made a dedicated table to make the requests in, but the principle could be done either in the clients table or Items table, in similar fasion! But done entirely without scripting...

--sd

test.zip

[Søren Dyhr]

However if you would do it without the extra table in a more

"Anchor Buoy/Hierarchical Table Occurence Grouping..." 'ish way

investigate this attachment - the topic as such can be studied here:

http://www.filemaker.com/downloads/pdf/FMDev_ConvNov05.pdf

(page37)

--sd

testModified.zip

[comment]

I think this can be built with less resources, using the method Ugo proposed here. Adding a table of Invoices would require LineItems to lookup the CustomerID and InvoiceDate from Invoices - but you can scroll Customers without setting a global.

LastPurchases4.fp7.zip

[Søren Dyhr]

Yeah! Ugo has a strong hand with relations, however is the storing of the looked up value taking a tad more storage, and is in the strictest sense redundant and builds yet another index, to send over a network.

--sd

[comment]

Well, if you want to live in style, you gotta pay the price...

[flapjacks]

Thanks to all. I have downloaded all the attachments. I appreciate your taking time to help with this.

John