Hi, You might also want to consider creating a StatusHistory-child-form where you store status-changes for your tickets. It is easier to do a lot of things if you have each status change as a separate record.
If you do not want to use the existing Status-History data, you might consider using the Run-Process-Command: PERFORM-ACTION-TABLE-ADD-ROW tableFieldID rowIndex Just go through your different status history entries to see if they are NULL or not, and add rows/set-values as needed. You will probably need to create one ACTL per Status-value to accomplish this. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > If you create a View form against the H table directly then you will only > receive 1 row back when you query for a specific Entry ID (Separate fields for > each status value and status value date). > > If you need multiple rows for a single entry then you can create a database > view against the H table and a View form against that. > > As an offhand question ... The Status History menu item is not good enough for > the users? > > Fred > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Hulmes, Timothy CTR MDA/ICTO > Sent: Wednesday, January 23, 2013 6:22 PM > To: arslist@ARSLIST.ORG > Subject: Reference the H-Table from a table field > > ** > Does anyone know if it is possible to display the H-Table on a form? > > What we are looking at doing is have a table on the form. In that table we > would like to display the status history. > > Any ideas? > > Tim > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"