How to get field information of another company?

Yabu13

Hi guys,

I have e.g. 5 companies. In Company A, there is a Boolean, which is only set in this company. In the other companies, I want to check all companies on the Boolean (in this case, it should find the Company A). If it's true, then I want to make CHANGECOMPANY on that company and get the specific field information from there.

Any ideas?

archer89

create a sql view in the database targeting table company information, which contains all fields.
create a new table in nav, which has the name of the sql view. set table properties DataPerCompany=No, LinkedObject=Yes. the new table contains all fields of table Company Information.
with that table you can then filter.