Kinook Software Forum

Go Back   Kinook Software Forum > Ultra Recall > [UR] General Discussion
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-11-2010, 11:41 PM
ashwken ashwken is offline
Registered User
 
Join Date: 10-16-2005
Location: Blairsville, GA USA
Posts: 431
Referential Integrity

The parent child relationship allows us to normalize the data structure:

for example, an invoice has a header section with a unique identifier, a date stamp, lookups to Contacts for Sold To, Ship To, Bill To (all the information to describe the invoice)

then you have one or more child items decribing what is being sold.

One method to insure referential integrity between parent and child records, is to create an attribute in the child record whose value is the unique identifier of the parent. In UR this is handled by the Data Explorer tree, but what happens if child records get misplaced by user error, become detached from their rightful inheritance.

As far as I can tell, this is partailly handled by the use of the Attribute Type - Info Item in the child record, but requires user input to set its value to anything beyond a default location.

Did a search on the title and came up empty, so I'm not sure if this has been addressed in v.4, but I am curious how others deal with this.
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 06:56 PM.


Copyright © 1999-2023 Kinook Software, Inc.