I want to create a Family database some of these "families " are single
fathers with children some are single women with children they will be
assigned Rooms /w children.
what would be the best to relate to the childrem ? 18 5155
Parent(s) are always a one-to-many relationship to children. You will need
two tables; one for parent(s) and ine for children. You are going to have to
decide how you are going to indicate a parent is a single parent and
implement that in the parent table.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications re******@pcdata sheet.com
"Cliff Chapin" <cc******@cox.n etwrote in message
news:d4******** ********@newsfe 10.phx...
>I want to create a Family database some of these "families " are single fathers with children some are single women with children they will be assigned Rooms /w children.
what would be the best to relate to the childrem ?
On Sat, 21 Jul 2007 22:49:59 GMT, "Steve" <So***@private. emailaddress>
wrote:
Not necessarily. Just think of the classic Employee table with a
ManagerID field and a self-join. Single table. Same applies here.
-Tom.
>Parent(s) are always a one-to-many relationship to children. You will need two tables; one for parent(s) and ine for children. You are going to have to decide how you are going to indicate a parent is a single parent and implement that in the parent table.
PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications re******@pcdat asheet.com
"Cliff Chapin" <cc******@cox.n etwrote in message news:d4******* *********@newsf e10.phx...
>>I want to create a Family database some of these "families " are single fathers with children some are single women with children they will be assigned Rooms /w children. what would be the best to relate to the childrem ?
"Cliff Chapin" <cc******@cox.n etwrote:
>I want to create a Family database some of these "families " are single fathers with children some are single women with children they will be assigned Rooms /w children. what would be the best to relate to the childrem ?
I'd create a family table and assign the parent(s) and children to the family.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
In the classic Employee table, managers are employees also so one table
suffices. In the OPs scenaro you can reasonably assume children CAN NOT be
parents so the two table approach is more appropriate.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications re******@pcdata sheet.com
"Tom van Stiphout" <no************ *@cox.netwrote in message
news:u1******** *************** *********@4ax.c om...
On Sat, 21 Jul 2007 22:49:59 GMT, "Steve" <So***@private. emailaddress>
wrote:
Not necessarily. Just think of the classic Employee table with a
ManagerID field and a self-join. Single table. Same applies here.
-Tom.
>>Parent(s) are always a one-to-many relationship to children. You will need two tables; one for parent(s) and ine for children. You are going to have to decide how you are going to indicate a parent is a single parent and implement that in the parent table.
PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Application s re******@pcda tasheet.com
"Cliff Chapin" <cc******@cox.n etwrote in message news:d4****** **********@news fe10.phx...
>>>I want to create a Family database some of these "families " are single fathers with children some are single women with children they will be assigned Rooms /w children. what would be the best to relate to the childrem ?
I hope this does not mislead the OP. Family to parent is a one-to-many
relationship and needs two tables. Family to children is also a one-to-many
relationship so this also needs two tables. The family solution thus needs a
TblFamily, TblParent and TblChild.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications re******@pcdata sheet.com
"Tony Toews [MVP]" <tt****@teluspl anet.netwrote in message
news:cu******** *************** *********@4ax.c om...
"Cliff Chapin" <cc******@cox.n etwrote:
>>I want to create a Family database some of these "families " are single fathers with children some are single women with children they will be assigned Rooms /w children. what would be the best to relate to the childrem ?
I'd create a family table and assign the parent(s) and children to the
family.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Steve, I don't think you understood Tony's response.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Steve" <So***@private. emailaddresswro te in message
news:Yq******** ********@newsre ad2.news.pas.ea rthlink.net...
>I hope this does not mislead the OP. Family to parent is a one-to-many relationship and needs two tables. Family to children is also a one-to-many relationship so this also needs two tables. The family solution thus needs a TblFamily, TblParent and TblChild.
"Tony Toews [MVP]" <tt****@teluspl anet.netwrote in message
news:cu******** *************** *********@4ax.c om...
>"Cliff Chapin" <cc******@cox.n etwrote:
>>>I want to create a Family database some of these "families " are single fathers with children some are single women with children they will be assigned Rooms /w children. what would be the best to relate to the childrem ?
I'd create a family table and assign the parent(s) and children to the family.
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
I took Tony's response to say a Family table with Parent1 and Parent2 fields
and Child1, Child2, Child3, etc fields. In the OP's scenario, it is
reasonable to assume he means young children who can njot also be parents.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications re******@pcdata sheet.com
"Allen Browne" <Al*********@Se eSig.Invalidwro te in message
news:46******** *************** @per-qv1-newsreader-01.iinet.net.au ...
Steve, I don't think you understood Tony's response.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Steve" <So***@private. emailaddresswro te in message
news:Yq******** ********@newsre ad2.news.pas.ea rthlink.net...
>>I hope this does not mislead the OP. Family to parent is a one-to-many relationshi p and needs two tables. Family to children is also a one-to-many relationship so this also needs two tables. The family solution thus needs a TblFamily, TblParent and TblChild.
"Tony Toews [MVP]" <tt****@teluspl anet.netwrote in message news:cu******* *************** **********@4ax. com...
>>"Cliff Chapin" <cc******@cox.n etwrote:
I want to create a Family database some of these "families " are single fathers with children some are single women with children they will be assigned Rooms /w children. what would be the best to relate to the childrem ?
I'd create a family table and assign the parent(s) and children to the family.
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
"Steve" <So***@private. emailaddresswro te in
news:Yq******** ********@newsre ad2.news.pas.ea rthlink.net:
I hope this does not mislead the OP. Family to parent is a
one-to-many relationship and needs two tables. Family to
children is also a one-to-many relationship so this also needs
two tables. The family solution thus needs a TblFamily,
TblParent and TblChild.
You are wrong again. You need a table for people, and a table
for unions(marriage s) and a table for children. People can be
parents of children and children of parents.
The unions table contains a candidate key of HusbandID and
WifeID, each tied to the PersonID in the people table
The Children table contains a foreign key to the PersonID in the
People table and foreign keys to the unions table.
Your way does not handle second mariages nor multiple
generations.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And
Word Applications re******@pcdata sheet.com
"Tony Toews [MVP]" <tt****@teluspl anet.netwrote in message
news:cu******** *************** *********@4ax.c om...
>"Cliff Chapin" <cc******@cox.n etwrote:
>>>I want to create a Family database some of these "families " are single fathers with children some are single women with children they will be assigned Rooms /w children. what would be the best to relate to the childrem ?
I'd create a family table and assign the parent(s) and children to the family.
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com
"Steve" <So***@private. emailaddresswro te in
news:zn******** ********@newsre ad2.news.pas.ea rthlink.net:
In the classic Employee table, managers are employees also so
one table suffices. In the OPs scenaro you can reasonably
assume children CAN NOT be parents so the two table approach
is more appropriate.
You can assume anything you like. You are the one making an ASS
out of U, not ME.
>
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And
Word Applications re******@pcdata sheet.com
"Tom van Stiphout" <no************ *@cox.netwrote in message
news:u1******** *************** *********@4ax.c om...
>On Sat, 21 Jul 2007 22:49:59 GMT, "Steve" <So***@private .emailaddresswr ote:
Not necessarily. Just think of the classic Employee table with a ManagerID field and a self-join. Single table. Same applies here.
-Tom.
>>>Parent(s) are always a one-to-many relationship to children. You will need two tables; one for parent(s) and ine for children. You are going to have to decide how you are going to indicate a parent is a single parent and implement that in the parent table.
PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications re******@pcd atasheet.com
"Cliff Chapin" <cc******@cox.n etwrote in message news:d4***** ***********@new sfe10.phx... I want to create a Family database some of these "families " are single fathers with children some are single women with children they will be assigned Rooms /w children. what would be the best to relate to the childrem ?
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Nicolas STAMPF |
last post by:
Hello,
I've just read documentation for both packages, and I can't seem to
decide which one to use.
I have some simple database things to do, but I'd like to have my code
prepared for possible future complications. I'm not going to use
Relations::Display or things like that, and I'll probably end up using
the Template Toolkit...
|
by: Fabian Neumann |
last post by:
Hi!
I got a problem with font-family inheritance. Let's say I have CSS
definitions like:
p {
font:normal 10pt Verdana;
}
strong {
font:normal 14pt inherit;
|
by: Robert Creager |
last post by:
I'm receiving the following error during startup:
Aug 10 14:11:27 thunder postgres: LOG: failed to create
socket: Address family not supported by protocol
Aug 10 14:11:27 thunder postgres: LOG: database system was
shut down at 2003-08-10 14:11:11 MDT
Aug 10 14:11:27 thunder postgres: LOG: checkpoint record is
at 4/E28389B4
|
by: Guy Naor |
last post by:
Hi,
Are there any built in or known structures I can use in Postgres to represent a family tree?
The usual tree representations in SQL are for regular hierarchy of data, but on a family each node had usually 2 parents and a few child nodes. What will be the best way to represent something like this in an efficient manner?
Guy.
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your...
|
by: Cliff Chapin |
last post by:
I am Constructing a family Database and want to know the best way to connect
non last names parents to the shildren a children sub form
| |
by: Erwin Moller |
last post by:
Hi group,
I could use a bit of guidance on the following matter.
I am starting a new project now and must make some decisions regarding
encoding.
Environment: PHP4.3, Postgres7.4.3
I must be able to receive forminformation and store that in a database and
later produce it on screen on the client (just plain HTML).
|
by: Rexcon |
last post by:
Hello I need help , and I have no clue how to start, Im doing a web page for my uncle and he wants me to do it, now he wants something like poeple search for a family name they type the name and will come up on the screen , something just like family search ancestry? can some one guide me or let me know please.
Thanks
|
by: redslider |
last post by:
now for my dumb-question (i note the other forum on 'inheritance' is closed):
my question is about inheriting text properties, and specifically, if font-family values can be cumulatively inherited? That is,
if i have a font-family in a parent div, and I specify 'font-family:"some font" in a child div, will the child also inherit the parent div's font-family if an instance fails to locate the child's specification? - in the sketchout...
|
by: Giampaolo Rodola' |
last post by:
Hi there,
since the socket.socket.family attribute has been introduced only in
Python 2.5 and I need to have my application to be backward compatible
with Python 2.3 and 2.4 I'd like to know how could I determine the
family of a socket.socket instance which may be AF_INET or AF_INET6.
Is there some kind of getsockopt() directive I could use?
For now I've been able to determine the family by using:
# self.socket = a connected...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |