drill down

gtrennert

Hello,

I would like to use the drill down functionnality to record changes to à history table. This seems to be possible - the budget module seems to do this (entering à new budget value => record to budget ledger of changes) - but I don't understand how it works !

details :
this should manage reevaluations in a very simple way :
a form on item ledger with a specific flowfield called Reevaluation Amount. the flowfield is the sum of aan amount field in a new table. when entering a value in the flowfield, it records it in the new table but I need to get there the item ledger entry n° too !

eromein

Well gtrennert,

The fact is Navision is misusing a Navision bug. In my humble opinion the functionality Navision made is very wrong.

So before explaining how it works, let me just say something to the developer of the lovely peace of development... You are a bad man, very bad man... (Please think of the Babau accent from Seinfeld yourself)

When you create a flowfield you should ALWAYS!!! make it non-editable. If you do not make it non-editable changes are you'll mess up your database. The field you are asking about is a flowfield gone mad! It's an editable flowfield. If you enter a value, Navision will automatically create new records in the table this field flow on (to, whatever it is called).

Better is to create your own little function that create records based on the value you enter. Then call this function in the onvalidate of your field. Just make some code that opend a form and call it from the Ondrilldown trigger of the field on the form to make it look like a flowfield. And.... you're done!

Hope... I got your question right, would be a pitty to have written all this for nothing!