473,326 Members | 2,255 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Linking database fields for automatic update of information

Morning everyone

I have made up a database to record generations of birds; along with others I have the following fields:

Ring number (primary key)
Sex
Year
Colour

Data entry via a form view.

For new entries I pick up from a combo box the parents, what I need to do now is create a relationship between 1, 3&4 and 2, 5&6 so that the data will automatically slot in the relevant fields.

1 Parent [censored]
2 Parent Hen
3 Grand Parent [censored] C/S
4 Grand Parent Hen C/S
5 Grand Parent [censored] H/S
6 Grand Parent Hen H/S

would I do it via a query.’ And would one cover relevant generations

Thanks for any help

Norma
Sep 20 '07 #1
3 1417
Scott Price
1,384 Expert 1GB
Morning everyone

I have made up a database to record generations of birds; along with others I have the following fields:

Ring number (primary key)
Sex
Year
Colour

Data entry via a form view.

For new entries I pick up from a combo box the parents, what I need to do now is create a relationship between 1, 3&4 and 2, 5&6 so that the data will automatically slot in the relevant fields.

1 Parent [censored]
2 Parent Hen
3 Grand Parent [censored] C/S
4 Grand Parent Hen C/S
5 Grand Parent [censored] H/S
6 Grand Parent Hen H/S

would I do it via a query.’ And would one cover relevant generations

Thanks for any help

Norma
The following link is to Allen Browne's website where he covers how to link a table to itself. The subject he is using is horse breeding/pedigrees, but should be adaptable to your situation as well. http://allenbrowne.com/ser-06.html

You might need to adjust the structure of your table, as his method does away with the need for Grand Parent fields.

The basic idea is to drag three copies of the same table into one query in design view. Rename two of them, then create the relationships by dragging the FatherID and MotherID fields to their respective locations. This can be repeated for as many layers of ancestors as desired.

Regards,
Scott
Sep 20 '07 #2
Hi Scott

Just had a look at what you have said and Allen Browne's example looks just what I need.

thanks for your help and I'm sure I'll be back.

Norma
Sep 20 '07 #3
Scott Price
1,384 Expert 1GB
Hi Scott

Just had a look at what you have said and Allen Browne's example looks just what I need.

thanks for your help and I'm sure I'll be back.

Norma
You're welcome, and welcome to the Scripts!

Regards,
Scott
Sep 20 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Craig | last post by:
Hi, I am storing information being sent to me weekly into a ms sql database. The one twist I am running into is that later down the line the information I recieve may require more columns, or...
11
by: dskillingstad | last post by:
I've been struggling with this problem for some time and have tried multiple solutions with no luck. Let me start with, I'm a novice at Access and I'm not looking for someones help to design my...
0
by: Pat Sagaser via .NET 247 | last post by:
I'm using a repeater with a dynamic template. I don't know the fields to display (or how many) until runtime. I have everything working except for linking Button events to the repeaters ItemCommand...
2
by: Dennis | last post by:
I hoping you might be able to help me with a small problem. I have made an application that links a VB.NET program to a database. After many failed attempts and reading I can add, delete, navigate...
3
by: josh.kuo | last post by:
Sorry about the subject, I can't think of a better one. I recently wrote some PHP classes that I think might be of interest to this group. Since I have been reaping the benefits of reading news...
2
by: MirzaSila | last post by:
I have a form whitch record source is one of the tables I have in my database.I have various text fields on that form whitch control sources are table fields.When I'm inputing text into these text...
4
by: =?Utf-8?B?QmFyYmFyYSBBbGRlcnRvbg==?= | last post by:
I setup a simple gridview as a utility just to do some updates, nothing fancy just wanted easy UI to make updates. When I select ‘Edit’, I get the fields I want to edit. I edit them and click...
6
by: bmoore | last post by:
Greetings, This seems like it should be a simple problem, but I'm new to Access and my digging hasn't yielded a solution. I would like to create a table in a non-protected database that contains...
2
by: rustyc | last post by:
Well, here's my first post in this forum (other than saying 'HI' over in the hi forum ;-) As I said over there: ... for a little side project at home, I'm writing a ham radio web site in...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.