Link factbox based on temporary table to Sales Lines NAV2009

rsaritzky

Hi all,

This question has been asked in a variety of ways/scenarios, but I did read as many topics as I could, but I don't think anyone confirmed this can be done.

This is NAV2009R2.
BTW, I did read the following thread - the last post on this thread is my question which is unanswered as far as I can tell.
viewtopic.php?f=5&t=20084&hilit=singleinstance&start=15

I will restate the scenario.

I want a factbox tied to the Sales Line table from the Sales order subform on the Sales order page.

The factbox is of type "Listpart".

What the factbox does is for the Item No. on the Sales line, it computes a bunch of availability information based on location - it's not the standard "Item Avail by location" info. So I built a function to compute this information and store the records in a new custom table "Item Availability Fact Box Source".

So, from a functional standpoint, what I want to do is:

a. When the user clicks on a sales line, the factbox recomputes the information for the item on that sales line
b. Redisplays the factbox with the current item's information.

The factbox needs to be a listpart because there are a variable number of lines.

In NAV2009, there's no OnAfterGetCurrRecord trigger. The only way I've read and/or discovered how to change the factbox contents in a subform is to use the ProviderID link, which means that the factbox must have the same source table as the calling subform.

Has anyone done this successfully? Steps? Examples?

Thanks

Ron