Print Page | Close Window

Query_Pedigree.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=62
Printed Date: 18 Dec 2017 at 7:57am


Topic: Query_Pedigree.mdb
Posted By: A.D. Tejpal
Subject: Query_Pedigree.mdb
Date Posted: 07 Jul 2008 at 11:13pm
This sample db demonstrates tracking of pedigree for cats upto 8th 
generation level. Base data is contained in table named T_Cats.

For convenience, identifier strings named ParentType are also generated. For 
example SS_2 means Sire > Sire, culminating in Gen Level 2.  Similarly, DSDSD_5 
means Dam > Sire > Dam > Sire > Dam, culminating in Gen Level 5.

In order to overcome the table limit inherent in nested queries with multiple tables 
(leading to the message that the query is too complicated), interim tables 
(T_Ped_6_01 to 04) have been used to store the results of sixth generation 
queries. These tables have in turn been used as the base for 7th generation 
onwards.

 With each higher generation level, additional columns get created in geometric 
progression. For proper presentation of final results and for smooth report 
generation, the output of these queries has been normalized (converting the 
columns into records) and appended to table T_Ped.

Although it does not take too long to process the existing data of 1175 records 
simultaneously without any filters, it is recommended that while generating the 
report, suitable range of ID's is selected. Otherwise, the unfiltered report containing 
pedigree information for all cats in source data will span more than 1800 pages.

In the results displayed immediately after processing of data, the record for original 
cat in each case is shown high-lighted in distinct color, while the records for 
parents are highlighted in separate colors for Male/Female. Similar pattern has 
been adopted for the report. 

Progress bar has been provided on data processing form. Existing 1175 records 
translate into an output of more than 20,000 records, taking approx. 26 
seconds

Download Access XP (A2K format): http://www.rogersaccesslibrary.com/forum/uploads/37/Query_Pedigree.zip -




Print Page | Close Window