hi Guys,
i have relationships like here:
full description of model you can find here:
https://www.access-programmers.co.uk/forums/showthread.php?t=304008
I have to change a little approach and need your help.
And now i have 2 tables: restrictedTable1 and restrictedTable2.
In each table you can see for which systemversion and topology i should restrict another systemversion for specific topology.
I created query to show what i want to:
so as you can see there are TopologyName and specific systemVersions for each of them.
And now each systemVersion specific for TopologyName should restrict usage of systemVersion characteristic for specififc Topology Name.
So systemVersion can restrict other SystemVersions based on restrictedTables dependencies.
Example:
In RestrictedTable2 there is topologyName FE in first column which should restrict Topology NW with specific SystemVersions,
So "SAP S/4HANA 1610 SP 01" for FE will restrict NW SystemVersions from table tblSystemVersion for only one choice: "SAP S/4HANA 1610 SP 01".
How can i appropriete restrict table tblSystemVersions using specific Topology Names and System Versions?
I thought to create one new table where i would put all dependencies.
But i do not know how to solve this technically.
Please help,
Best Wishes,
Jacek
i have relationships like here:
full description of model you can find here:
https://www.access-programmers.co.uk/forums/showthread.php?t=304008
I have to change a little approach and need your help.
And now i have 2 tables: restrictedTable1 and restrictedTable2.
In each table you can see for which systemversion and topology i should restrict another systemversion for specific topology.
I created query to show what i want to:
so as you can see there are TopologyName and specific systemVersions for each of them.
And now each systemVersion specific for TopologyName should restrict usage of systemVersion characteristic for specififc Topology Name.
So systemVersion can restrict other SystemVersions based on restrictedTables dependencies.
Example:
In RestrictedTable2 there is topologyName FE in first column which should restrict Topology NW with specific SystemVersions,
So "SAP S/4HANA 1610 SP 01" for FE will restrict NW SystemVersions from table tblSystemVersion for only one choice: "SAP S/4HANA 1610 SP 01".
How can i appropriete restrict table tblSystemVersions using specific Topology Names and System Versions?
I thought to create one new table where i would put all dependencies.
But i do not know how to solve this technically.
Please help,
Best Wishes,
Jacek