Mark, If your going down to the DB level anyways...
Look at the T and H tables for the forms your interested in. (Or maybe the Views that Remedy creates if they include the Status History stuff too.) If your view joins 2 T and 2H tables into one view then I think you should be able to expose the Status History values as fields instead of the normal "Status History" construct. Maybe that will solve your issue? If you do not know how to find the right T,H tables just ask. :) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. Never ascribe to malice, that which can be explained by incompetence. On 8/18/06, Mark Bee <[EMAIL PROTECTED]> wrote:
Hi, This is my scenario: I need to join two forms in such way: select * from FormA union all select * from FormB Since there is no way to do it through a join form so I use a view form witch gets the data from a database view (executing above sql code) But the manual says that status history field is not suported on view forms.And that's just what I need. Have you got any solution for me? MarkB
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
