家庭数据库 [英] family database
问题描述
我想创建一个家庭数据库中的一些家庭。是单身
有孩子的父亲有些是有孩子的单身女性他们将是
分配房间/ w孩子。
什么是最好的与childrem有关？
父母一直是与孩子的一对多关系。你需要
两张桌子;一个用于父母，一个用于儿童。你将不得不
决定你如何表明父母是单亲，并且
在父表中实现。
PC数据表
为客户提供访问，Excel和Word帮助的资源
应用程序
re ****** @ pcdatasheet.com
" Cliff Chapin" < cc ****** @ cox.netwrote in message
news：d4 **************** @ newsfe10.phx ...
>我想创建一个家庭数据库中的一些家庭。有孩子的单身父亲有些是带孩子的单身女性，他们将被分配房间/孩子。
什么是最好的与孩子有关？
2007年7月21日星期六，格林尼治标准时间22:49:59，史蒂夫 < So *** @ private.emailaddress>
写道：
不一定。只需考虑带有
ManagerID字段和自联接的经典Employee表。单桌。这同样适用于此。
-Tom。
>父母一直是 - 和孩子们有很多关系。你需要两张桌子;一个用于父母，一个用于儿童。您将不得不决定如何表明父母是单亲，并在父表中实施。
PC数据表
提供客户获取Access，Excel和Word帮助的资源
应用程序
re******@pcdatasheet.com
" Cliff Chapin" < cc ****** @ cox.netwrote in message
新闻：d4 **************** @ newsfe10.phx ...
< blockquote class =post_quotes>
>>我想创建一个Family数据库，其中一些是family。有孩子的单身父亲有些是有孩子的单身女性，他们会被分配房间/孩子。
最好与childrem有什么关系？
" Cliff Chapin" < cc ****** @ cox.netwrote：
>我想创建一个家庭数据库中的一些家庭。有孩子的单身父亲有些是带孩子的单身女性，她们会被分配房间/孩子。
最适合与孩子有关的事情是什么？
我会创建一个家庭表并将父母和孩子分配给家庭。
Tony
-
Tony Toews，Microsoft Access MVP
请仅在新闻组中回复，以便其他人可以
阅读整个消息主题。
Microsoft Access Links，Hints，Tips&会计系统
http://www.granite.ab.ca /accsmstr.htm
Tony的Microsoft Access博客 - http://msmvps.com/blogs/access/
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 ?
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******@pcdatasheet.com
"Cliff Chapin" <cc******@cox.netwrote in message
news:d4****************@newsfe10.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******@pcdatasheet.com
"Cliff Chapin" <cc******@cox.netwrote in message
news:d4****************@newsfe10.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.netwrote:
>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/
这篇关于家庭数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
