Hi, I want to create a table to include additional information for a User login.

Like email address, department, location....etc.

But I want to create the display/maintian session such that data from same table is viewed. i.e. not company specific tables.

Via ttaad4100 I can create the table but that data should be viewed in session in all companies..

how ?

Hi,

you need to create the table in one company and use then the compnr field in the where.
select ttmmmnnn.*
from ttmmmmnnn
where .......
and tmmmnnn._compnr = "xxx"

Other solution :
create a table and shared with all companies (logical tables see session ttaad4120m000)
if the companies are all in the same VRC.

Regards
Philippe

In your session try a query.extension where you select only records of company 000 or switch in before.program section to company 000.

thanks Philippe and wiggum

I will try these options.

I am aware of the select statement with _compnr option but how will it work in standard Baan maintain session ? Probably i will try the switch to option

Hi,

In a maintain session I think that you can add the selection via query.extension but Wiggum's proposal is the best in your case

Regards