Question about TableRelation and OnLookup trigger

fabrizioc

Dear all, I need an advice on how to modify an existing behavior, in a dynamics nav 2009 system we have a table with the following code in TableRelation field

IF (Bank Payment Type=CONST(Bank Transfer)) "Bank Account" ELSE IF (Bank Payment Type=CONST(Computer Check)) "Bank Account" ELSE IF (Bank Payment Type=CONST(Manual Check)) "Bank Account" ELSE IF (Bank Payment Type=CONST(CIL)) Vendor ELSE IF (Bank Payment Type=CONST(InterCompany)) Vendor

Now a new requirement ask us to modify the behavior opening a different form if the Company is a new specific one.......
so I'd like to add another IF statement to test the CompanyInfo and performs a different action

Do I have to put the code in a OnLookup trigger or is possible to extend this IF statements serie to include the CompanyInfo ?

How can I populate the CompanyInfo information before using it in TableRelation condition ?

Thank you in advance for your feedback.

Best regards
Fabrizio

mohana_cse06

its not possible to use in table relation.
you need to completely move existing functionality also to onlookup

fabrizioc

Thank you Mohana, can you suggest me a quick hint ? Do I have to call SETTABLEVIEW function in OnLookup trigger code ?
If yes can you provide me a small snippet or a link to an example?

Thank you again for your help.
Best regards
Fabrizio