table relationships

[Bruno]

i have a db with 5 tables. the first tabel timember with memberid being pk
and the field Partner id linked to a table memberspartners on the field
partnerid. then i have table3 deathdate linked to memberid iof of table
timember. then table four is ParetnChild Relationship with Memberid field
linked to Memberid of timember tabel finally tabel 5 childrenofmembers with
childid linked to childid filed of ParentChild Realtionship . i haven't
started entering data yet but was wondering if Access 2007 will automatically
(not manually by me) enter all the id fields values or will i have to keep
inserting via keyboard the id values for all the id fields?

 

[Jerry Whittle]

If you have the relationships between the tables formally defined in the
Relationship Window with referiential integrity enable AND then use build
form/subforms to enter the data, Access will.

 

[John W. Vinson]

i have a db with 5 tables. the first tabel timember with memberid being pk
and the field Partner id linked to a table memberspartners on the field
partnerid. then i have table3 deathdate linked to memberid iof of table
timember. then table four is ParetnChild Relationship with Memberid field
linked to Memberid of timember tabel finally tabel 5 childrenofmembers with
childid linked to childid filed of ParentChild Realtionship . i haven't
started entering data yet but was wondering if Access 2007 will automatically
(not manually by me) enter all the id fields values or will i have to keep
inserting via keyboard the id values for all the id fields?

No, Access will not and cannot automagically determine which family a child is
in when you start entering data for a child.

And no, you should never even need to *SEE* the MemberID or ChildID field,
much less type them in!!!

I am guessing that the problem is arising because you're trying to enter data
directly into Tables. Don't. That's not their function; tables are
repositories to *store* data. The proper tool to enter and edit data is not a
table, but a Form.

Create a Form with Subforms; each "one" side of a relationship should be
displayed on a Form, with the "many" table on a subform on that form.

See some of these references for how to make the best use of the tools Access
provides:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

John W. Vinson [MVP]

 

[Bruno]

do u mean have a form for timembers and one form for each of the other
tables? i'm unfamiliar with access so subforms doesn't really mean much to
me. if u could explain or i could use the help file that would help. but
thanks for your help so far.

 

[John W. Vinson]

do u mean have a form for timembers and one form for each of the other
tables? i'm unfamiliar with access so subforms doesn't really mean much to
me. if u could explain or i could use the help file that would help. but
thanks for your help so far.

Take a look at the tutorials I posted - sorry, but I'm packing for a week-long
trip tomorrow and won't be able to reply in detail.

John W. Vinson [MVP]

 

[Bruno]

hi john,
i managed to create the form and two subforms .. however i had four records
in the tables and only one was entered in the created form and subform. so is
there a way to magically transfer the other three records to the forms? or
should i delete all the records from the table and start the numbering over
in the forms?
have a terrific holiday .. i await your return.

 

[John W. Vinson]

hi john,
i managed to create the form and two subforms .. however i had four records
in the tables and only one was entered in the created form and subform. so is
there a way to magically transfer the other three records to the forms? or
should i delete all the records from the table and start the numbering over
in the forms?
have a terrific holiday .. i await your return.

It was a working trip not a holiday, and a bit of a bummer in some ways, but
I'm back intact.

You don't need to "transfer the records to the forms". Forms ARE JUST WINDOWS
- they don't contain any data; they *display* data which is stored in your
Table. If the form is correctly designed, you should be able to use its
navigation buttons or other tools to see all of the data which is stored in
the Table or tables being used as the form's recordsource.

If you are having trouble doing so, please post the forms' Recordsource
properties, and the Master/Child Link Fields of the subforms.

John W. Vinson [MVP]