child link to itself

I have a child table which has composite key ID and CID which both
link to parent table like following.

I would like to know is it bizard design like this?

tblParent

ID long integer primary key
MyDate Date Time

tblChild

ID long integer primary key
CID long integer primary key
ChildField Text(50)


Data will be

Parent table
ID MyDate
1 01/20/2008
2 03/15/2007
3 04/01/2008

Child table

ID CID ChildField
1 2 First time
1 3 Second time


Your information is great appreciated,

Consider doing this:

tblParent
- IDparent, autonumber

tblChild
- CID, autonumber
- IDparent, long, DefaultValue -- null
- CID_, long, DefaultValue -- null

When a table is liked to itself, I like to use its primary key fieldname
with an underscore

When you make the relationship on the relationship diagram, Access will
put another copy of the table on the diagram -- the copy will have a
"_1" on the end of the name

~~~

it was hard to answer your question when you refer to 'parent' and
'child' -- please use the real names of your data so we can give you a
better answer ... I am not really following how you want the
relationships to be set up


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*




inungh wrote:
I have a child table which has composite key ID and CID which both
link to parent table like following.

I would like to know is it bizard design like this?

tblParent

ID long integer primary key
MyDate Date Time

tblChild

ID long integer primary key
CID long integer primary key
ChildField Text(50)


Data will be

Parent table
ID MyDate
1 01/20/2008
2 03/15/2007
3 04/01/2008

Child table

ID CID ChildField
1 2 First time
1 3 Second time


Your information is great appreciated,

On Aug 15, 12:45*pm, strive4peace wrote:
Consider doing this:

tblParent
- IDparent, autonumber

tblChild
- CID, autonumber
- IDparent, long, DefaultValue -- null
- CID_, long, DefaultValue -- null

When a table is liked to itself, I like to use its primary key fieldname
with an underscore

When you make the relationship on the relationship diagram, Access will
put another copy of the table on the diagram -- the copy will have a
"_1" on the end of the name

~~~

it was hard to answer your question when you refer to 'parent' and
'child' -- please use the real names of your data so we can give you a
better answer ... I am not really following how you want the
relationships to be set up

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP..com/strive4peace

* *
* * (: have an awesome day
* *



inungh wrote:
I have a child table which has composite key ID and CID which both
link to parent table like following.

I would like to know is it bizard design like this?

tblParent

ID * * * * * * *long integer *primary key
MyDate * * *Date Time

tblChild

ID * * * * * * long integer * * primary key
CID * * * * * long integer * * primary key
ChildField *Text(50)

Data will be

Parent table
ID * * * * * * MyDate
1 * * * * * * 01/20/2008
2 * * * * * * 03/15/2007
3 * * * * * * 04/01/2008

Child table

ID * * *CID * *ChildField
1 * * * *2 * *First time
1 * * * *3 * *Second time

Your information is great appreciated,- Hide quoted text -

- Show quoted text -

Thanks for the information,

"Thanks for the information"

you're welcome happy to help

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*




inungh wrote:
On Aug 15, 12:45 pm, strive4peace wrote:
Consider doing this:

tblParent
- IDparent, autonumber

tblChild
- CID, autonumber
- IDparent, long, DefaultValue -- null
- CID_, long, DefaultValue -- null

When a table is liked to itself, I like to use its primary key fieldname
with an underscore

When you make the relationship on the relationship diagram, Access will
put another copy of the table on the diagram -- the copy will have a
"_1" on the end of the name

~~~

it was hard to answer your question when you refer to 'parent' and
'child' -- please use the real names of your data so we can give you a
better answer ... I am not really following how you want the
relationships to be set up

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*



inungh wrote:
I have a child table which has composite key ID and CID which both
link to parent table like following.
I would like to know is it bizard design like this?
tblParent
ID long integer primary key
MyDate Date Time
tblChild
ID long integer primary key
CID long integer primary key
ChildField Text(50)
Data will be
Parent table
ID MyDate
1 01/20/2008
2 03/15/2007
3 04/01/2008
Child table
ID CID ChildField
1 2 First time
1 3 Second time
Your information is great appreciated,- Hide quoted text -
- Show quoted text -

Thanks for the information,

On Aug 18, 9:03*am, strive4peace wrote:
"Thanks for the information"

you're welcome *happy to help

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP..com/strive4peace

* *
* * (: have an awesome day
* *



inungh wrote:
On Aug 15, 12:45 pm, strive4peace wrote:
Consider doing this:

tblParent
- IDparent, autonumber

tblChild
- CID, autonumber
- IDparent, long, DefaultValue -- null
- CID_, long, DefaultValue -- null

When a table is liked to itself, I like to use its primary key fieldname
with an underscore

When you make the relationship on the relationship diagram, Access will
put another copy of the table on the diagram -- the copy will have a
"_1" on the end of the name

~~~

it was hard to answer your question when you refer to 'parent' and
'child' -- please use the real names of your data so we can give you a
better answer ... I am not really following how you want the
relationships to be set up

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP.com/strive4peace

* *
* * (: have an awesome day
* *

inungh wrote:
I have a child table which has composite key ID and CID which both
link to parent table like following.
I would like to know is it bizard design like this?
tblParent
ID * * * * * * *long integer *primary key
MyDate * * *Date Time
tblChild
ID * * * * * * long integer * * primary key
CID * * * * * long integer * * primary key
ChildField *Text(50)
Data will be
Parent table
ID * * * * * * MyDate
1 * * * * * * 01/20/2008
2 * * * * * * 03/15/2007
3 * * * * * * 04/01/2008
Child table
ID * * *CID * *ChildField
1 * * * *2 * *First time
1 * * * *3 * *Second time
Your information is great appreciated,- Hide quoted text -
- Show quoted text -

Thanks for the information,- Hide quoted text -

- Show quoted text -

I had table to link to itself like supervisor links to employee table
itself. It is my first time that child links to its parent.

I have problem to find records which child does not exists.
Are there any specific way to find child link does not exist?

For exmaple,

Parent table have following data

ID
1
2
3
4

Child has following data

ID ChildID
1 2
1 4


Child ID link to Parent table ID.
Are there any way to find ID 3 in the parent table?

Your help is great appreciated,

"Are there any specific way to find child link does not exist?"

SELECT Parent.ID
FROM Parent LEFT JOIN Child On Parent.ID=Child.ID
WHERE Child.ID Is Null


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*




inungh wrote:
On Aug 18, 9:03 am, strive4peace wrote:
"Thanks for the information"

you're welcome happy to help

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*



inungh wrote:
On Aug 15, 12:45 pm, strive4peace wrote:
Consider doing this:
tblParent
- IDparent, autonumber
tblChild
- CID, autonumber
- IDparent, long, DefaultValue -- null
- CID_, long, DefaultValue -- null
When a table is liked to itself, I like to use its primary key fieldname
with an underscore
When you make the relationship on the relationship diagram, Access will
put another copy of the table on the diagram -- the copy will have a
"_1" on the end of the name
~~~
it was hard to answer your question when you refer to 'parent' and
'child' -- please use the real names of your data so we can give you a
better answer ... I am not really following how you want the
relationships to be set up
Warm Regards,
Crystal
remote programming and training
Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP.com/strive4peace
*
(: have an awesome day
*
inungh wrote:
I have a child table which has composite key ID and CID which both
link to parent table like following.
I would like to know is it bizard design like this?
tblParent
ID long integer primary key
MyDate Date Time
tblChild
ID long integer primary key
CID long integer primary key
ChildField Text(50)
Data will be
Parent table
ID MyDate
1 01/20/2008
2 03/15/2007
3 04/01/2008
Child table
ID CID ChildField
1 2 First time
1 3 Second time
Your information is great appreciated,- Hide quoted text -
- Show quoted text -
Thanks for the information,- Hide quoted text -
- Show quoted text -

I had table to link to itself like supervisor links to employee table
itself. It is my first time that child links to its parent.

I have problem to find records which child does not exists.
Are there any specific way to find child link does not exist?

For exmaple,

Parent table have following data

ID
1
2
3
4

Child has following data

ID ChildID
1 2
1 4


Child ID link to Parent table ID.
Are there any way to find ID 3 in the parent table?

Your help is great appreciated,

On Aug 19, 6:46*pm, strive4peace wrote:
"Are there any specific way to find child link does not exist?"

SELECT Parent.ID
FROM Parent LEFT JOIN Child On Parent.ID=Child.ID
WHERE Child.ID Is Null

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP..com/strive4peace

* *
* * (: have an awesome day
* *



inunghwrote:
On Aug 18, 9:03 am, strive4peace wrote:
"Thanks for the information"

you're welcome *happy to help

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP.com/strive4peace

* *
* * (: have an awesome day
* *

inunghwrote:
On Aug 15, 12:45 pm, strive4peace wrote:
Consider doing this:
tblParent
- IDparent, autonumber
tblChild
- CID, autonumber
- IDparent, long, DefaultValue -- null
- CID_, long, DefaultValue -- null
When a table is liked to itself, I like to use its primary key fieldname
with an underscore
When you make the relationship on the relationship diagram, Access will
put another copy of the table on the diagram -- the copy will have a
"_1" on the end of the name
~~~
it was hard to answer your question when you refer to 'parent' and
'child' -- please use the real names of your data so we can give you a
better answer ... I am not really following how you want the
relationships to be set up
Warm Regards,
Crystal
remote programming and training
Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP.com/strive4peace
* *
* * (: have an awesome day
* *
inunghwrote:
I have a child table which has composite key ID and CID which both
link to parent table like following.
I would like to know is it bizard design like this?
tblParent
ID * * * * * * *long integer *primary key
MyDate * * *Date Time
tblChild
ID * * * * * * long integer * * primary key
CID * * * * * long integer * * primary key
ChildField *Text(50)
Data will be
Parent table
ID * * * * * * MyDate
1 * * * * * * 01/20/2008
2 * * * * * * 03/15/2007
3 * * * * * * 04/01/2008
Child table
ID * * *CID * *ChildField
1 * * * *2 * *First time
1 * * * *3 * *Second time
Your information is great appreciated,- Hide quoted text -
- Show quoted text -
Thanks for the information,- Hide quoted text -
- Show quoted text -

I had table to link to itself like supervisor links to employee table
itself. It is my first time that child links to its parent.

I have problem to find records which child does not exists.
Are there any specific way to find child link does not exist?

For exmaple,

Parent table have following data

ID
1
2
3
4

Child has following data

ID *ChildID
1 * * *2
1 * * *4

Child ID link to Parent table ID.
Are there any way to find ID 3 in the parent table?

Your help is great appreciated,- Hide quoted text -

- Show quoted text -

Thanks for helping,
I beleive my problem is the child links to parent.
Actually, Child is parent of parent table,
In this case , child is parent. am I right?

Thanks again,

On Aug 20, 8:11*am, inungh wrote:
On Aug 19, 6:46*pm, strive4peace wrote:





"Are there any specific way to find child link does not exist?"

SELECT Parent.ID
FROM Parent LEFT JOIN Child On Parent.ID=Child.ID
WHERE Child.ID Is Null

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP.com/strive4peace

* *
* * (: have an awesome day
* *

inunghwrote:
On Aug 18, 9:03 am, strive4peace wrote:
"Thanks for the information"

you're welcome *happy to help

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP.com/strive4peace

* *
* * (: have an awesome day
* *

inunghwrote:
On Aug 15, 12:45 pm, strive4peace wrote:
Consider doing this:
tblParent
- IDparent, autonumber
tblChild
- CID, autonumber
- IDparent, long, DefaultValue -- null
- CID_, long, DefaultValue -- null
When a table is liked to itself, I like to use its primary key fieldname
with an underscore
When you make the relationship on the relationship diagram, Access will
put another copy of the table on the diagram -- the copy will have a
"_1" on the end of the name
~~~
it was hard to answer your question when you refer to 'parent' and
'child' -- please use the real names of your data so we can give you a
better answer ... I am not really following how you want the
relationships to be set up
Warm Regards,
Crystal
remote programming and training
Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP.com/strive4peace
* *
* * (: have an awesome day
* *
inunghwrote:
I have a child table which has composite key ID and CID which both
link to parent table like following.
I would like to know is it bizard design like this?
tblParent
ID * * * * * * *long integer *primary key
MyDate * * *Date Time
tblChild
ID * * * * * * long integer * * primary key
CID * * * * * long integer * * primary key
ChildField *Text(50)
Data will be
Parent table
ID * * * * * * MyDate
1 * * * * * * 01/20/2008
2 * * * * * * 03/15/2007
3 * * * * * * 04/01/2008
Child table
ID * * *CID * *ChildField
1 * * * *2 * *First time
1 * * * *3 * *Second time
Your information is great appreciated,- Hide quoted text -
- Show quoted text -
Thanks for the information,- Hide quoted text -
- Show quoted text -

I had table to link to itself like supervisor links to employee table
itself. It is my first time that child links to its parent.

I have problem to find records which child does not exists.
Are there any specific way to find child link does not exist?

For exmaple,

Parent table have following data

ID
1
2
3
4

Child has following data

ID *ChildID
1 * * *2
1 * * *4

Child ID link to Parent table ID.
Are there any way to find ID 3 in the parent table?

Your help is great appreciated,- Hide quoted text -

- Show quoted text -

Thanks for helping,
I beleive my problem is the child links to parent.
Actually, Child is parent of parent table,
In this case , child is parent. am I right?

Thanks again,- Hide quoted text -

- Show quoted text -

Thanks I got this works.
in this case, I have my child as parent then it works now.
Thanks again,

you're welcome happy to help


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*




inungh wrote:
On Aug 20, 8:11 am, inungh wrote:
On Aug 19, 6:46 pm, strive4peace wrote:





"Are there any specific way to find child link does not exist?"
SELECT Parent.ID
FROM Parent LEFT JOIN Child On Parent.ID=Child.ID
WHERE Child.ID Is Null
Warm Regards,
Crystal
remote programming and training
Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP.com/strive4peace
*
(: have an awesome day
*
inunghwrote:
On Aug 18, 9:03 am, strive4peace wrote:
"Thanks for the information"
you're welcome happy to help
Warm Regards,
Crystal
remote programming and training
Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP.com/strive4peace
*
(: have an awesome day
*
inunghwrote:
On Aug 15, 12:45 pm, strive4peace wrote:
Consider doing this:
tblParent
- IDparent, autonumber
tblChild
- CID, autonumber
- IDparent, long, DefaultValue -- null
- CID_, long, DefaultValue -- null
When a table is liked to itself, I like to use its primary key fieldname
with an underscore
When you make the relationship on the relationship diagram, Access will
put another copy of the table on the diagram -- the copy will have a
"_1" on the end of the name
~~~
it was hard to answer your question when you refer to 'parent' and
'child' -- please use the real names of your data so we can give you a
better answer ... I am not really following how you want the
relationships to be set up
Warm Regards,
Crystal
remote programming and training
Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP.com/strive4peace
*
(: have an awesome day
*
inunghwrote:
I have a child table which has composite key ID and CID which both
link to parent table like following.
I would like to know is it bizard design like this?
tblParent
ID long integer primary key
MyDate Date Time
tblChild
ID long integer primary key
CID long integer primary key
ChildField Text(50)
Data will be
Parent table
ID MyDate
1 01/20/2008
2 03/15/2007
3 04/01/2008
Child table
ID CID ChildField
1 2 First time
1 3 Second time
Your information is great appreciated,- Hide quoted text -
- Show quoted text -
Thanks for the information,- Hide quoted text -
- Show quoted text -
I had table to link to itself like supervisor links to employee table
itself. It is my first time that child links to its parent.
I have problem to find records which child does not exists.
Are there any specific way to find child link does not exist?
For exmaple,
Parent table have following data
ID
1
2
3
4
Child has following data
ID ChildID
1 2
1 4
Child ID link to Parent table ID.
Are there any way to find ID 3 in the parent table?
Your help is great appreciated,- Hide quoted text -
- Show quoted text -
Thanks for helping,
I beleive my problem is the child links to parent.
Actually, Child is parent of parent table,
In this case , child is parent. am I right?

Thanks again,- Hide quoted text -

- Show quoted text -

Thanks I got this works.
in this case, I have my child as parent then it works now.
Thanks again,