Steven,
Do both tables have the same structure?
>Sergey,
>
>Here is my select statement:
>
>Select t1.dmdrno, t1.dmpchg, t1.dmtitle, t1.dmnosht, t1.dmsize, t1.dmjob1, findcustomer(t1.dmdrno, t1.dmpchg) As Customer, t1.fn2, t1.ln2, t1.codate, t1.pe1d, IIF(IsNull(canby),"",canby) As canby, IIF(IsNull(candt),{},candt) As candt, Not IsNull(t2.candt) As canceled ;
>From changetable t1 ;
>Left Join kuwcd t2 On t2.dmdrno == t1.dmdrno And t2.dmpchg == t1.dmpchg Where t1.dmdrno == icdwgno ;
>InTo Cursor IndexCardr
>
>This works almost perfect. However, If a drawing number/revision change is canceled it will no longer reside in the changetable. As a result the above select statement will not display this revision unless it is checked out again for changes.
>
>Here is the practical seniro: "A" is checked out and released(record in changetable). "B" checked out and released(record in changetable). "C1" checked out then canceled(record in changetable deleted, record in kuwcd inserted). "C" checked out and released(record in changetable.
>
>The above select statement would never show any activity for the "C1" revision. I need to show every activity for each drawing.
--sb--