Hello There!
I am trying to develop a CMDB on our system, and we want to be able to view the servers with their different kinds of information. We have about 30 or so specifications on servers, so we thought of splitting this information based on type (backup details, monitoring details, security details, etc...) into different tabs (with different restrictions based on which servers to be listed in each tab).
I tried setting the main application's dataset in all the tables in the tabs, but the only issue was the filtration, i.e. let's say Server X is monitored but not backed up, and Server Y is not monitored but backed up. Searching but both servers show up in both lists regardless of the queries in 'Application Restriction' or relationships of a table.
We also tried using different data sources to solve the above issue, which fixed it, but also disabled being able to select a record and the filtration is not linked with the other tables in other tabs.
My question here is, can I achieve sharing a dataset between two tables and have additional filtration per table?
Any assistance would be much appreciated