Axton, I will probably use joins in some fashion, maybe for a report form. At the top level I think it will be the main form with tables and DO fields to display data, with Open Window actions to create/modify children records.
I wasn't planning on using the GUID, instead I was just going to use the Request_ID of the parent. Child records are created from modify screens. Aside from the lack of a Request ID at the create time of the parent are ther other benefits to the GUID? Or where you using the general term guid? Thanks for the reminder about indexing. ARS 6.3 Patch 003 Midtier 6.3 Patch 14 MS SQL 2000 SP2 on a remote SAN John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
