Philip P

Hello, I am in desperate need for someone to sort my database in a complicated sort of way. This should be easy for the experianced and I will pay around $20US for it to be done properly. See this project page for more info and how to bid (mention fmforums when you bid please) http://www.getafreelancer.com/projects/13472.html Thanks!

I looked at your attachment and understood most of it but I still couldn't integrate it into my template. ? Thanks for the help so far.

Thanks for the answer, but I cant properly integrate your answer. Could you do it for me or give me clearer steps please?

I've just started trying out filemaker 7, (I'm converting from Access). I've managed to use the Product Catalog Template and modify it to my needs so it looks and acts like my access database except for one thing. I'm tring to implicated a fairly difficult sorting solution. Heres what it is: Each Record has one assigned keyword and a price value. I want each record which has the same keyword to find the total average of price. This average is then sorted accending with the other keyword price averages. This is probably have to be done in script, if anyone could help, it would be great! I'll give a gmail account too if you want. Database: http://www.philzones.com/WineryAttemp2.fp7