Retrieve company name a user is working on

iqbalmad wrote:

wat if i have several companies???

You can only be logged into one company at a time.

I am sure that you could do something like this:

Create a table with UserID, LoginTime, LogoutTime (add a date field(s) if you feel this is necessary).
Or as Revolution1210 said...tweak the User Time Register.

Record the UserID, LoginTime when Logging In (CodeUnit 1 > CompanyOpen)
Record the UserID, LogoutTime when Logging Out (CodeUnit 1 > CompanyClose)

This table will exist for each of the 3 companies but create a view in SQL Server that looks at all companies via a Union Query.

The SQL Query would simply be 3 Select statements (1 per company) for all LogoutTime Values = '1/1/1753' (this is equal to 0D in Navision in my version of SQL, not sure what it would be for your installation/locale), tied together via Union statements.

Something like this:

SELECT 'Company A' AS Company, UserID, LoginTime
FROM dbo.[CompanyA$NewTable]
WHERE ([LogoutTime] = CONVERT(DATETIME, '1753-01-01 00:00:00', 102))
UNION
SELECT 'Company B' AS Company, UserID, LoginTime
FROM dbo.[CompanyB$NewTable]
WHERE ([LogoutTime] = CONVERT(DATETIME, '1753-01-01 00:00:00', 102))
UNION
SELECT 'Company C' AS Company, UserID, LoginTime
FROM dbo.[CompanyC$NewTable]
WHERE ([LogoutTime] = CONVERT(DATETIME, '1753-01-01 00:00:00', 102))

Your results would look something like:
CompanyA Jack 10:03 AM
CompanyB Terry 09:20 AM
CompanyC Natasha 08:47 AM

Link your form to the results of the new SQL Server View < I've never linked to a view before but I think this is possible.
If not, there are other ways to pump the information back into Navision (i.e. SQL Stored Procedures).

*****edit ****

I hope this helps.

headley27 wrote:

I am sure that you could do something like this:

..long story with SQL views etc...

Or you just uncheck the "DataPerCompany" property of the table