Den Fong, That is a bit of a tough question to answer with the input that you have supplied. I tend to think that the "proper" way to do things would be based on what your tying to do.
To be clear there are multiple types of relationships between data records. Depending on the type of relationship your trying to model will dictate (to some extent) the "best or proper" way to use keys like GUID. The relationship you described sounds like a one (parent) to many (children). However the relationship could be "one to one", "many to many", "one to none" (exclusive condition), or even "one to N" (where N is a fixed number). If we are talking about a one to many in this case, then I think your ok with what your doing. However pushing the Parent 'Request ID' to the child seems redundant to the parent GUID value. It might be useful for things like reporting, but you could also get that from a Join of the Parent and Child based on the Parent GUID value too. But that has more to do with how you use the data then the "proper" way to keep the relationship between the records. While it may not matter, to much, I would reserve the use of field 179 as "This records GUID value". So I would advocate NOT storing the 'Parent GUID' in field 179 on the child. And in fact the child may not need a field 179 in this case. However for a "many to many" relationship it would likely be needed. HTH. -- 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 5/16/06, Den Fong <[EMAIL PROTECTED]> wrote:
** Hi All I just want to make sure I am using the GUID field poperly for my forms. I have a separate form that is a child of tasks, so I place a GUID field (179) on the tasks form. Generate the GUID on submit and then push the GUID, along with all the other fields, to the child form. Then when the task is submitted and task ID is generated I have to go and poplulate the child with the task ID? My one question is on the child form do I make the the other field a GUID (179) field as well or should I use a char field? TIA. ARS 6.01 ITSM 5.6 Den Fong Husky Energy Inc. 707-8th Avenue SW Calgary, Alberta CANADA T2P 3G7 Phone : 1-403-298-7244
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
