Howdy,
I've been away from Access for a few years, just trying to get my legs back under me.
I have a challenge to create a relational database of horses. The primary hurdle I can't get over is this:
Primary info, each record will have unique registration number (key), a field for sire (father) and dam (mother) for each horse. These fields will be horses also in the database.
I need to be able to query the pedigree(heritage if you will) back 5 generations. I'm stuck as to how to do that.
IE: Great/Great Grandad(G5)
Great Grandad (G4) " Grandma
Grandad(dads)(G3) Great Grandma " Grandad
DAD(G2) Grandma(dads) Great Grandad " Grandma
Great Grandad " Grandad
" Grandma
Me (Gen 1) " Grandad
" Grandma
MOM(G2) Great/Great Grandad(G5)
Granddad(moms)(G3) Great Grandad (G4) " Grandma
Grandma(moms) Great Grandma " Grandad
Great Grandad " Grandma
Great Grandma " Grandad
" Grandma
" Grandad
" Grandma
I can do the form layouts, prints, etc, but having trouble setting up the query to get all this for the original Gen 1.
Any assistance I can find is appreciated.
10 6430
Sorry - My layout didn't work out the way I planned.
Basically, I need the equivalent of a geneology tree for one horse going back 5 generations.
Thanks
Dan
As i understand it you have a table with two foreign keys set to its own primary key. In a query you will have to have three instances of the table.
tblHorses
tblHorses_1 'First foreign key joined to primary key of first instance
tblHorses_2 'Second foreign key joined to primary key of first instance
This should allow you to query all decendants
Howdy,
I've been away from Access for a few years, just trying to get my legs back under me.
I have a challenge to create a relational database of horses. The primary hurdle I can't get over is this:
Primary info, each record will have unique registration number (key), a field for sire (father) and dam (mother) for each horse. These fields will be horses also in the database.
I need to be able to query the pedigree(heritage if you will) back 5 generations. I'm stuck as to how to do that.
IE: Great/Great Grandad(G5)
Great Grandad (G4) " Grandma
Grandad(dads)(G3) Great Grandma " Grandad
DAD(G2) Grandma(dads) Great Grandad " Grandma
Great Grandad " Grandad
" Grandma
Me (Gen 1) " Grandad
" Grandma
MOM(G2) Great/Great Grandad(G5)
Granddad(moms)(G3) Great Grandad (G4) " Grandma
Grandma(moms) Great Grandma " Grandad
Great Grandad " Grandma
Great Grandma " Grandad
" Grandma
" Grandad
" Grandma
I can do the form layouts, prints, etc, but having trouble setting up the query to get all this for the original Gen 1.
Any assistance I can find is appreciated.
As i understand it you have a table with two foreign keys set to its own primary key. In a query you will have to have three instances of the table.
tblHorses
tblHorses_1 'First foreign key joined to primary key of first instance
tblHorses_2 'Second foreign key joined to primary key of first instance
This should allow you to query all decendants
Thanks - I'll see if that makes sense to me and I can get it to work.
Dan VW
I have a challenge to create a relational database of horses. The primary hurdle I can't get over is this:
Primary info, each record will have unique registration number (key), a field for sire (father) and dam (mother) for each horse. These fields will be horses also in the database.
I need to be able to query the pedigree(heritage if you will) back 5 generations. I'm stuck as to how to do that.
IE: Great/Great Grandad(G5)
Great Grandad (G4) " Grandma
Grandad(dads)(G3) Great Grandma " Grandad
DAD(G2) Grandma(dads) Great Grandad " Grandma
Great Grandad " Grandad
" Grandma
Me (Gen 1) " Grandad
" Grandma
MOM(G2) Great/Great Grandad(G5)
Granddad(moms)(G3) Great Grandad (G4) " Grandma
Grandma(moms) Great Grandma " Grandad
Great Grandad " Grandma
Great Grandma " Grandad
" Grandma
" Grandad
" Grandma
Hi
I've only just come across your post. Did you manage to do this ok? I have a dog pedigree database that is the same as this. if you want to see how it's done give me a shout.
Jill
Hi
I've only just come across your post. Did you manage to do this ok? I have a dog pedigree database that is the same as this. if you want to see how it's done give me a shout.
Jill
Jill,
I am just trying to set up a 5 generation Connemara Pony database and I would appreciate any guidance you can give me.
Thanks
Hi
I've only just come across your post. Did you manage to do this ok? I have a dog pedigree database that is the same as this. if you want to see how it's done give me a shout.
Jill
Jill,
I am trying to set up a dog pedigree database and would love to see how you did it.
Alan
Jill,
I am trying to set up a Quarter Horse database and I would like to make pedigrees but I got a little stuck.
Can you help me on my way?
Thanks
Hi
I've only just come across your post. Did you manage to do this ok? I have a dog pedigree database that is the same as this. if you want to see how it's done give me a shout.
Jill
Jill,
or anyone who got a copy of Jill's database. I am stuggling to set up a database for my small cattle farm. Could I look at how you did it with the dog's.
Any help would be appreciated.
Dave
Jill,
or anyone who got a copy of Jill's database. I am stuggling to set up a database for my small cattle farm. Could I look at how you did it with the dog's.
Any help would be appreciated.
Dave
Same goes for me. If Jill or someone can pass along Jill's database, that would be awesome. I'm trying to set up something for our Border Collies. Don't want to end up putting in a ton of info and then finding out I didn't set things up right to begin with.
Thanks!
Chris
It's quite possible to do all of this in a custom Access database, but I think that for it to work efficiently, you'll end up needing quite extensive coding to build some sort of temporary table with all the generation info. The thought of trying to do this using nested queries just doesn't sound appealing.
As an alternative, why don't you consider using one of the many freeware family tree programs which you can find on the internet? Try a Google search for "family tree programs". I say this because designing the queries is only the beginning - the design of a report to display the generations intelligibly will probably present its own challenges.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: karolina |
last post by:
Hi,
I am making a small registration form about cars in three steps. The
first step is to fill in member data. After filled out the member data
hit "next" and enter car information. Hit "next"...
|
by: Steven Stern |
last post by:
I'm stuck on a host that is still running MYSQL version 3.
I need to flatten out a relationship to AND a set of criteria.
In a nutshell
User
UserID
UserEmail
UserOther
|
by: Marcel - IDUG Europe 2005 |
last post by:
Dear DB2 user,
My name is Marcel Lévy and I'm a member of the IDUG 2005 Europe
Conference Planning Committee.
*********************************************************************
Mark your...
|
by: Marcel - IDUG Europe 2005 |
last post by:
Hi DB2 users,
=========================================================================================
We just created a blog dedicated to our upcoming IDUG 2005 Europe
Conference
(24-28...
|
by: Daz Talbot |
last post by:
Hi there
Does anyone know if it is possible to invoke the SQL Server Query Builder
from within a VB.NET program.
I'd like to have query building functionality within my application.
Thanks...
|
by: Marcel - IDUG Europe 2006 |
last post by:
Hi DB2 user,
Register by 14 September and Save 226 Euro!
Register by Thursday, 14 September and save 226 Euro on your full
conference registration! Don't wait - make sure you take advantage of...
|
by: Philip_collins |
last post by:
Hi!
the following sql is identical to code in another database of mine. in
the first database it works perfectly, that is to say it writes the
query and I have a form based on the query. in the...
|
by: JT |
last post by:
Hi,
I would like opinions on a shareware issue. If shareware uses an
online database to hold registration codes, which get copied locally
and therefore only needs to check online if the...
|
by: satishknight |
last post by:
Hi,
Can some one tell me how to change the validation sequence for the code pasted below, actually what I want it when any one enters the wrong login information (already registered users) then it...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |