Advanced DB functions in Filemaker?

[fedekugen]

I'm trying to use filemaker as an automatic database who recives data from a media workflow management system. I've writen a script that analyses whats in the third post and creates new posts and also calculates new values in other new posts. The problem is that there will be about 25 different values that will need to be changed and calculated. Example: Data: NA, SUM 4000 should become:NA=US.CA.SD.HU.BE and SUM*0.6 SUM*0.24 SUM *0.03 etc This is done by a Loop/if script. But as the script grows speed goes down etc. Is there another wa of doing this?

/H

[keshalyi]

Well... I dont quite know what determines the correlation between the two values, but if its just a simple 'this value from the source should be this value in the final product', why not set up those pairs in a static, seperate table? Then just have an import bridge file that would import the source value, figure out the corresponding value for the receptor by a relationship to the static table, then output a file iwth the newer values?

[fedekugen]

The values are the real problem, there is a relationship between five counties that should pay a certain percentage of the full price, example: US:60% CA:25% SE:10% FI:12% DK: 3%. The problem is that sometimes only US and SE should pay but the internal relationship between them: 60/10 should be the same. This is of course also the case if US, CA, SE and DK should pay the amount. Example: US.SE: relationship 60/10 but to get what each country should pay calculate and then US=85,71 and SE=14,29 in order to pay the whole price.

Thank you for taking your time.