Table Relation

Hi All, I need to use two different tables to be selected simultaniously as table relation to provide different look up tables based on value in another table. I can able to do it based on value from the same table. This is required to be done with purchase header table field - “Buy from vendor number”. Is there any way to do this in navision? Best regards, Hari

Just copy the field from your other table into the Purchase Header table. But why Are you changing the TableRelation of the “Buy-from Vendor No.” field[?]

Hi Nelson, Thanks for this.I have done the same thing before you replied.Still, is any another option is available other than this? Best Regards Hari