You can take advantage of Aware IM feature known as 'matching attribute' to establish visibility from Lic all the way back to Client. For example, you can add attribute Client of type Client to object R_System that will be a matching attribute of attribute System on object Client. The matching attributes describe the same link, so when you add a System on the form for Client, the attribute Client on R_System will be automatically initialised to point to the Client. Of course, you can now place attribute Client on the form for R_System so you can navigate from R_System to its related Client. Similarly, you can add matching attributes for other objects so the model looks like this:
att: System --Type: R_System
att: Trial --Type: y/n
att: Name --Type: Plain Text
att: R_Servers --Type: R_Server
att: Client --Type: Client (matching to Client.System)
att: Lic --Type: R_Lic
att: System --Type: R_System (matching to R_System.R_Servers)
att: Finish_Date --Type: Date
att: Created --Type: Date
att: Server --Type: R_Server (matching to R_Server.Lic)
To add attribute Client to R_System, open object R_System for editing in the Configuration Tool, click Add in the attribute section, and select Client as the attribute type. Click 'Existing' in the Matching Attributes In Client, select System as the matching attribute name, make sure Multiple Allowed box is not ticked (this is important).
Repeat the steps to add necessary matching attributes to the other two objects. Now you can use an expression R_Lic.Server.System.Client anywhere in the system to access Client from R_Lic.
The next step is to add an attribute ClientName of type Shortcut to object R_Lic. When prompted for Attribute Path, enter Server.System.Client.Name. Now you can configure a simple query on object R_Lic, sorted in descending order of R_Lic.Finish_Date that will display attributes Finish_Date and ClientName. This way you will see all instances of Lic with finish dates and client names with the most recent displayed on top of the list.
If, on the other hand, you want to see only the latest license for a server, you can do the following. Add attribute LatestLicense of type Date to R_Server. Add a rule to R_Server that will automatically register the date of the latest license with the server. The rule will look like this:
If R_Lic WAS ADDED TO R_Server.Lic
Then R_Server.LatestLicense = AddedR_Lic.Finish_Date
Next, add an attribute ClientName of type Shortcut to object R_Server with path System.Client.Name. Now you can configure a query on object R_Server that will display attributes LatestLicense and ClientName.
Let us know if you need more details.
Aware IM Support Team