Joining

[Guest]

Hello,
Back again....remember I am a novice at this if you reply ....

So, I've created this database to capture foster parent registration
information, such as when they registered, when they attended class, etc.

I created a table for their demographic information, a table for the
training information and then a snapshot table which will hold all of the
information I need to see at a glance.

My issue, how do I get Table 2 to update information from Table 1...for
instance....the demographic information from Table 1 contains the ID
number....I want that ID number to be updated in the Training Table so that
when i enter the contact information in Table 1..the ID number will update in
Table 2 .....I hope this makes sense

 

[Guest]

Hi

Sorry but that not the way it works. - well you "can" update information
from table 1 into table 2. But in your case I don't think thats what you are
looking for,

Your tables should be
Table1
Details of forster parents
This will contain a unique identifer (I would use an autonumner as the ID)
ParentID = Autonumber
1stname
2ndName
OtherNames
Sex = Mr, Mrs, Miss, Mrs, etc etc
Address (split this down into individual lines)
AddressLine1
AddressLine2
etc.
Postcode/zipcode
Notes (memo field)
etc
etc
etc

Table2 (training)
CourseId (autonumber) The unique identifier for this course.
ParentID = number field (this is the linking field)
CourseTitle
CourseDate
Location
Results
etc
etc
etc

Link the ParentID in both tables (use the relationship window for this)

You will then be able to create a query to provide the "snapshot" you need.
It is important the link the table so that if a parent goes on more than 1
course you don't need to rewite (and store) the same parent details in
another record.

Search the help file (F1) for more information on Relationships.

Hope this helps