create tables

hi,
i have two tables one called personel info and the other called affiliation
(taekwondo). I would like to be able to enter dats in personel info and the
information goes directly to the affiliation table. i have similar fields
with the same type of field. the tables are one to one and i reinforce
referrential integrity but still it does not work. any help? thanks

I think you need to better explain what you are attempting to do. Normally
you would only store values in one table.

Can you describe your tables/fields and what type of field values you think
should go into both tables?

--
Duane Hookom
MS Access MVP
--

"jiji" wrote in message
.. .
hi,
i have two tables one called personel info and the other called
affiliation (taekwondo). I would like to be able to enter dats in personel
info and the information goes directly to the affiliation table. i have
similar fields with the same type of field. the tables are one to one and
i reinforce referrential integrity but still it does not work. any help?
thanks

On Sat, 21 Jan 2006 23:11:35 -0500, "jiji"
wrote:

hi,
i have two tables one called personel info and the other called affiliation
(taekwondo). I would like to be able to enter dats in personel info and the
information goes directly to the affiliation table. i have similar fields
with the same type of field. the tables are one to one and i reinforce
referrential integrity but still it does not work. any help? thanks


In a relational database, you should use the "Grandmother's Pantry
Principle": "A place - ONE place! - for everything, everything in its
place".

The affiliation table should contain the unique ID of the person, *and
nothing else about the person*. Storing their name or age in the
second table is neither necessary nor beneficial; if you need to see
that information in conjunction with the affliation information,
you'ld use a Query joining the two tables.

John W. Vinson[MVP]

my first table has an ID as a primary key and contain all the personal
info(name, adress, tel...) the other table called affiliation has the ID
again plus the affiliation no( if the person is affiliated if not the field
should stay empty) it also has the name, dojan no, level,.price..... I do
not know if I should use a one to one relationship because in both tables
the ID number should be entered once but my problem is the affiliation no.
the main purpose of those 2 tables is to be be able to make a form that
shows the person info and if he is affiliated to the affiliation (if he has
an affiliation no) I hope i made myself more clear. thank you
"Duane Hookom" a écrit dans le message de
news: ...
I think you need to better explain what you are attempting to do. Normally
you would only store values in one table.

Can you describe your tables/fields and what type of field values you
think should go into both tables?

--
Duane Hookom
MS Access MVP
--

"jiji" wrote in message
.. .
hi,
i have two tables one called personel info and the other called
affiliation (taekwondo). I would like to be able to enter dats in
personel info and the information goes directly to the affiliation table.
i have similar fields with the same type of field. the tables are one to
one and i reinforce referrential integrity but still it does not work.
any help? thanks

If I understand correctly, you would use your first table as the record
source of the main form. Create a subform for the related records. The
related table needs to store primary key value from the main table. This is
set up by using the Link Master/Child properties of the subform control.

--
Duane Hookom
MS Access MVP
--

"jiji" wrote in message
news
my first table has an ID as a primary key and contain all the personal
info(name, adress, tel...) the other table called affiliation has the ID
again plus the affiliation no( if the person is affiliated if not the
field should stay empty) it also has the name, dojan no, level,.price.....
I do not know if I should use a one to one relationship because in both
tables the ID number should be entered once but my problem is the
affiliation no. the main purpose of those 2 tables is to be be able to
make a form that shows the person info and if he is affiliated to the
affiliation (if he has an affiliation no) I hope i made myself more
clear. thank you
"Duane Hookom" a écrit dans le message de
news: ...
I think you need to better explain what you are attempting to do. Normally
you would only store values in one table.

Can you describe your tables/fields and what type of field values you
think should go into both tables?

--
Duane Hookom
MS Access MVP
--

"jiji" wrote in message
.. .
hi,
i have two tables one called personel info and the other called
affiliation (taekwondo). I would like to be able to enter dats in
personel info and the information goes directly to the affiliation
table. i have similar fields with the same type of field. the tables are
one to one and i reinforce referrential integrity but still it does not
work. any help? thanks

thanks for replying, the thing is i need two forms on the screen: the
personel info and the affiliation but i would like to be able to print the
affilialtion form right away if the person is affiliated , so i still need
his or her personal info to be repeated in the the affiliation form as well
"Duane Hookom" a écrit dans le message de
news: ...
If I understand correctly, you would use your first table as the record
source of the main form. Create a subform for the related records. The
related table needs to store primary key value from the main table. This
is set up by using the Link Master/Child properties of the subform
control.

--
Duane Hookom
MS Access MVP
--

"jiji" wrote in message
news
my first table has an ID as a primary key and contain all the personal
info(name, adress, tel...) the other table called affiliation has the ID
again plus the affiliation no( if the person is affiliated if not the
field should stay empty) it also has the name, dojan no,
level,.price..... I do not know if I should use a one to one relationship
because in both tables the ID number should be entered once but my
problem is the affiliation no. the main purpose of those 2 tables is to
be be able to make a form that shows the person info and if he is
affiliated to the affiliation (if he has an affiliation no) I hope i made
myself more clear. thank you
"Duane Hookom" a écrit dans le message de
news: ...
I think you need to better explain what you are attempting to do.
Normally you would only store values in one table.

Can you describe your tables/fields and what type of field values you
think should go into both tables?

--
Duane Hookom
MS Access MVP
--

"jiji" wrote in message
.. .
hi,
i have two tables one called personel info and the other called
affiliation (taekwondo). I would like to be able to enter dats in
personel info and the information goes directly to the affiliation
table. i have similar fields with the same type of field. the tables
are one to one and i reinforce referrential integrity but still it does
not work. any help? thanks

Whoa. Now you are talking about printing. I don't think anyone knows enough
about your table structure and your original question.

Reports are for printing. If you have a question about creating reports,
please ask a specific question the the Access Reports news group. Try to be
fairly descriptive of what you have and what you need.

--
Duane Hookom
MS Access MVP
--

"jiji" wrote in message
...
thanks for replying, the thing is i need two forms on the screen: the
personel info and the affiliation but i would like to be able to print the
affilialtion form right away if the person is affiliated , so i still need
his or her personal info to be repeated in the the affiliation form as
well
"Duane Hookom" a écrit dans le message de
news: ...
If I understand correctly, you would use your first table as the record
source of the main form. Create a subform for the related records. The
related table needs to store primary key value from the main table. This
is set up by using the Link Master/Child properties of the subform
control.

--
Duane Hookom
MS Access MVP
--

"jiji" wrote in message
news
my first table has an ID as a primary key and contain all the personal
info(name, adress, tel...) the other table called affiliation has the ID
again plus the affiliation no( if the person is affiliated if not the
field should stay empty) it also has the name, dojan no,
level,.price..... I do not know if I should use a one to one
relationship because in both tables the ID number should be entered once
but my problem is the affiliation no. the main purpose of those 2 tables
is to be be able to make a form that shows the person info and if he is
affiliated to the affiliation (if he has an affiliation no) I hope i
made myself more clear. thank you
"Duane Hookom" a écrit dans le message
de news: ...
I think you need to better explain what you are attempting to do.
Normally you would only store values in one table.

Can you describe your tables/fields and what type of field values you
think should go into both tables?

--
Duane Hookom
MS Access MVP
--

"jiji" wrote in message
.. .
hi,
i have two tables one called personel info and the other called
affiliation (taekwondo). I would like to be able to enter dats in
personel info and the information goes directly to the affiliation
table. i have similar fields with the same type of field. the tables
are one to one and i reinforce referrential integrity but still it
does not work. any help? thanks

On Sun, 22 Jan 2006 09:06:45 -0500, "jiji"
wrote:

my first table has an ID as a primary key and contain all the personal
info(name, adress, tel...)

That is the ONLY table which should contain this information.

the other table called affiliation has the ID
again plus the affiliation no( if the person is affiliated if not the field
should stay empty) it also has the name, dojan no, level,.price.....

If by the name, you mean the person's name - remove it from this
table. It should NOT be stored redundantly in two different tables.

I do
not know if I should use a one to one relationship because in both tables
the ID number should be entered once but my problem is the affiliation no.

Can one person have more than one affiliation? Or can one affliation -
whatever that is; is this an affiliation with a dojan, whatever a
dojan is (I'm not familiar with the term) have more than one
affiliate?

the main purpose of those 2 tables is to be be able to make a form that
shows the person info and if he is affiliated to the affiliation (if he has
an affiliation no) I hope i made myself more clear. thank you

Please explain what an "affiliation" means. You may need an additional
table, but I'm not at all certain.

John W. Vinson[MVP]

Ok, my main question for now, how can i enter an information in one table
and the other table will be updated automatically without having to enter
the info two times ex: when i enter the ID number in the personal info, this
ID will be automatically entered in the affiliation table. what type of
relationship should those tables have?

"Duane Hookom" a écrit dans le message de
news: ...
Whoa. Now you are talking about printing. I don't think anyone knows
enough about your table structure and your original question.

Reports are for printing. If you have a question about creating reports,
please ask a specific question the the Access Reports news group. Try to
be fairly descriptive of what you have and what you need.

--
Duane Hookom
MS Access MVP
--

"jiji" wrote in message
...
thanks for replying, the thing is i need two forms on the screen: the
personel info and the affiliation but i would like to be able to print
the affilialtion form right away if the person is affiliated , so i still
need his or her personal info to be repeated in the the affiliation form
as well
"Duane Hookom" a écrit dans le message de
news: ...
If I understand correctly, you would use your first table as the record
source of the main form. Create a subform for the related records. The
related table needs to store primary key value from the main table. This
is set up by using the Link Master/Child properties of the subform
control.

--
Duane Hookom
MS Access MVP
--

"jiji" wrote in message
news my first table has an ID as a primary key and contain all the personal
info(name, adress, tel...) the other table called affiliation has the
ID again plus the affiliation no( if the person is affiliated if not
the field should stay empty) it also has the name, dojan no,
level,.price..... I do not know if I should use a one to one
relationship because in both tables the ID number should be entered
once but my problem is the affiliation no. the main purpose of those 2
tables is to be be able to make a form that shows the person info and
if he is affiliated to the affiliation (if he has an affiliation no) I
hope i made myself more clear. thank you
"Duane Hookom" a écrit dans le message
de news: ...
I think you need to better explain what you are attempting to do.
Normally you would only store values in one table.

Can you describe your tables/fields and what type of field values you
think should go into both tables?

--
Duane Hookom
MS Access MVP
--

"jiji" wrote in message
.. .
hi,
i have two tables one called personel info and the other called
affiliation (taekwondo). I would like to be able to enter dats in
personel info and the information goes directly to the affiliation
table. i have similar fields with the same type of field. the tables
are one to one and i reinforce referrential integrity but still it
does not work. any help? thanks

Generally you create a record in the "other table" when you need to store
something in the "other table". This is done with a form and subform as I
mentioned earlier.

The only values that would normally be stored in both tables is the primary
key from the main table as the foreign key in the "other table".

--
Duane Hookom
MS Access MVP
--

"jiji" wrote in message
...
Ok, my main question for now, how can i enter an information in one table
and the other table will be updated automatically without having to enter
the info two times ex: when i enter the ID number in the personal info,
this ID will be automatically entered in the affiliation table. what type
of relationship should those tables have?

"Duane Hookom" a écrit dans le message de
news: ...
Whoa. Now you are talking about printing. I don't think anyone knows
enough about your table structure and your original question.

Reports are for printing. If you have a question about creating reports,
please ask a specific question the the Access Reports news group. Try to
be fairly descriptive of what you have and what you need.

--
Duane Hookom
MS Access MVP
--

"jiji" wrote in message
...
thanks for replying, the thing is i need two forms on the screen: the
personel info and the affiliation but i would like to be able to print
the affilialtion form right away if the person is affiliated , so i
still need his or her personal info to be repeated in the the
affiliation form as well
"Duane Hookom" a écrit dans le message
de news: ...
If I understand correctly, you would use your first table as the record
source of the main form. Create a subform for the related records. The
related table needs to store primary key value from the main table.
This is set up by using the Link Master/Child properties of the subform
control.

--
Duane Hookom
MS Access MVP
--

"jiji" wrote in message
news my first table has an ID as a primary key and contain all the personal
info(name, adress, tel...) the other table called affiliation has the
ID again plus the affiliation no( if the person is affiliated if not
the field should stay empty) it also has the name, dojan no,
level,.price..... I do not know if I should use a one to one
relationship because in both tables the ID number should be entered
once but my problem is the affiliation no. the main purpose of those 2
tables is to be be able to make a form that shows the person info and
if he is affiliated to the affiliation (if he has an affiliation no) I
hope i made myself more clear. thank you
"Duane Hookom" a écrit dans le message
de news: ...
I think you need to better explain what you are attempting to do.
Normally you would only store values in one table.

Can you describe your tables/fields and what type of field values you
think should go into both tables?

--
Duane Hookom
MS Access MVP
--

"jiji" wrote in message
.. .
hi,
i have two tables one called personel info and the other called
affiliation (taekwondo). I would like to be able to enter dats in
personel info and the information goes directly to the affiliation
table. i have similar fields with the same type of field. the tables
are one to one and i reinforce referrential integrity but still it
does not work. any help? thanks