Add a field into a list view from another table

maffyooz

My users are running form 132 (Posted Sales Invoice) then upon clicking the list button displays form 143 (Posted Sales Invoices) here they are wishing to view the Credit Controller field (number 87014) from the Sales Header table (number 36).

How can i add this extra field into the list requested from the Posted Sales Invoices form?

Thanks guys. ](*,)

awarn

Maybe what you should do is add that field (use the same field #) to the Posted Sales Header table, then add the field to the form.

-a

kine

It depend on relations between these two tables... if you can define lookup FlowField in table 132 connected to the field in table 36, or second way is to modify OnAfterGetRecord of the form, create new global var, add one column with this variable to the table box and in the trigger, fill it with apropriate value...