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 ;)
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.
#1
André Arnaud de Cal...
294,261
Super User 2025 Season 1
#2
Martin Dráb
233,009
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
