Help with this question please!

HCL Domino Domino Forum
1

I’m doing a database where i manage data for allocating employee’s to their workstations. Such as Employee A is attached to workstation 10 etc.

I’m not sure if there’s a better way, i only know the basics of DD. So what i do is that, i have 2 databases, A contains the workstation information while B contains the form which keys in employee’s data and also attaches the employees to the workstation. So database B has a field which dbcolumn database A’s workstation number.

So the problem now is that, i want to create a view in database B such that i can view all the workstations and also have one of the column to be the employee’s name that is attached to the workstation. So, to view all the workstations i would need to use the field from database A and the employee’s name from database B. However, both fields cannot be displayed side by side because they are not in anyway connected. If i were to use the workstation number and the employees’ name from database B, however only the workstation in use are displayed while the vacant workstations are not displayed. So how can i make that happen?

My main objective is to be able to view which workstations are in use and which are vacant.

Thx for reading!!

2

Subject: RE: Help with this question please!

With “regular” Notes, you can only have data on a view row that comes from the (one) document shown on that row. So you would have to, for instance, write an agent to periodically update the machine records with the username.

If you store the databases in NSFDB2 format, then you could use DAVs and a QV to do a relational join of the data.

The third choice is to create an unused workstation report agent that would run against the data in both databases and generate a report (which might be rich text containing doclinks) of the unused systems.