Table relations by code

(0) Share

Report

Posted on by Community Member

Hello all,

I have created a field that has a table relation on the Purchase header. But now it can be that the displayed purchase order is archived and thus the field is emptied.

How can I tell the system to execute one Table Relation for one value and the other Table Relation for the other value, depending on a condition? I want one Table Relation to go to the orders and the other to the order archive,depending on which condition is true?

Thank you ;)

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Greg Enns 1,106 on at

Like (0)

Report

You would need another field on the current record, to indicate if the Table Relation should be to the PurchaseHeader or PurchaseHeaderArchive. For example, the field could be a boolean called "IsArchived".

You should be able to follow the pattern used for the "No." field on the PurchaseLine table. The "Type" field is the indicator that adjusts the Table Relation for the "No." field.

Was this reply helpful? Yes No