Creating a View based on another View
I have the following tables:
table 1 (Object List):
- ID Object
table 2 (Object Reference):
- ID Object 1
- ID Object 2
Now I need to get the <table1.Key> of the referring Object from <table2> with a selection condition concerning <table1.Key> (Some Keys are only for Projects, others for certain Documents, so I need the related Document Key to a certain Project Key).
Part 1 - I would choose all <ID Objects> from <table1> related to <ID Object 2> from <table2> that meet the selection condition for their <Keys> in <table1> and select by joining the related <ID Object 1> from <table 2>.
Part 2 - After that I choose those <Keys> from <table1> which have the concerning <ID Object 1> from <table2>.
I hope everybody is confused now
With my "solution" I would need to proceed a view (part 2) based on another view (part 2), which the workbench doesn't allow me to do, cause a view cannot get its data from another view but only from a basis database table.
Many thanks in advance.