From a design standpoint, you don't want to get into the business of
duplicating data. Your data just ends up turning into a mess and simple operations like updating the profile of a set of users ends up being a resource intensive operation. Not only that, it bloats your applications.
From a maintenance perspective, you don't want to get into the
business of customizing the out of the box workflow, simply because it's something you HAVE to own when you do an upgrade. I emphasize HAVE because that workflow you customized to do what you want will surely change or cease to exist when you do an upgrade. If you can get away with it, create a view field on the HD form, then create a set of active links that populate the data when someone views or creates a ticket. You can make it more aesthetically appealing using this method as well. Now if only the arodbc driver were up to par, you could join people and hd to get that fax number in a report; unless I gave up on the odbc driver before that, and similar, core capabilities were added... Axton Grams On 7/26/07, Brad Terhune <[EMAIL PROTECTED]> wrote:
Good afternoon listers! I was hoping you all could help me with a bit of form to form shuffling. On our SHR:People form we are running a daily update out of our Oracle personnel database that populates certain fields in SHR:People. Not all of those fields show up on the HPD:Helpdesk form (Support view) when we query up users and create tickets. Clicking the Profile button and bringing up SHR:People shows the fields and information, but I want those fields to actually appear on the HPD:Helpdesk form when we query someone up. For example, "Fax Number" is on the SHR:People form but not on the HPD:Helpdesk form. Does anyone know of a good way to populate that data on the HPD:Helpdesk form? It does not appear to be as easy as calling a Set Fields AL from the SHR:People form to HPD:Helpdesk. Any help would be appreciated. Thanks, Brad _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"