Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have two tables like this.
Margin:
LOAD [SC-IM],
GROUP,
[Job Name],
DESCRIPTION,
[Critical ?],
SLA,
[Last Run date],
[Last Run time],
trim([Last Run Timestamp]) as [Last End Timestamp],
trim(PREDECESSOR) as Predecessors,
trim(SUCCESSOR) as Successors
Resident Temp order by [Last Run Timestamp] asc,[Job Name] asc;
SUCCESSOR:
LOAD [Job Name] as "Parent Job",
trim(mid(trim(subfield(Successors,',')),2)) as "Child Job"
Resident Margin order by [Job Name] asc;
Now i have to create two table objects like. If a "Job Name" is selected from List
1. object-Table1 should list all the columns of "Margin" table -- done
2. object-Table2 should look up "Margin".[Job Name] for each value of "SUCCESSOR".[Child Job] and list all detail for that Child job from "Margin"-- Is it possible ?
Any help is highly appreciated. Thanks in advance
MidhunGT
try like this:
add a column like this
This should work.