creatiing new field in 2nd and 3rd tablr from first table

[labernethy]

The problem:
I have date tequairing almost 450 separate fields and have
created 3 tables to deal with this.

the problem is linkin the 3 fields together.

I'm trying to create a record in the first table and have the key
feild replicated to the 2nd and 3rd tables creating a new record in
those tables.

the problem is: everthing i've done overwites the last record in the
2nd and 3rd tables.

Problem 2 is i don'd know vb and i'm trying to do this throught the
properties windows of the various queries, tables and forms i've tried
to do this with.

I understand the links, indexes and key concepts. i'm missing the
knowlegde to to span multipletable with information related to the
same id number.

HELP

LA

 

[Arvin Meyer [MVP]]

Let me start by saying that there has NEVER been a relational database that
required 450 fields. I suggest that you read:

Database Design for Mere Mortals by Michael J. Hernandez.

That said, the only ways you can connect tables synchronously is through
code in a form, or by using a linked subform.

 

[John W. Vinson]

The problem:
I have date tequairing almost 450 separate fields and have
created 3 tables to deal with this.

Sorry, but I DOUBT IT.

I've needed as many as 60 fields... once, in the past twenty years. "Fields
are expensive, records are cheap"!

I think that you must have some repeating groups of fields. If you have fields
named April, May, June; or Question1, Question2, Question3, etc., then you
would benefit from normalizing the data structure, splitting the one to many
relationships out of each record into two or more tables.

What are some examples of your fields?

the problem is linkin the 3 fields together.

I'm trying to create a record in the first table and have the key
feild replicated to the 2nd and 3rd tables creating a new record in
those tables.

A Form with a Subform, using the three fields (separated by semicolons) as the
Master/Child Link Field, will work.

the problem is: everthing i've done overwites the last record in the
2nd and 3rd tables.

Please describe what you're doing. It's hard to tell what you're doing wrong
(other than using 450 fields in the table in the first place!!!) since you
don't say what you're doing.

Problem 2 is i don'd know vb and i'm trying to do this throught the
properties windows of the various queries, tables and forms i've tried
to do this with.

No VB is needed (for this), but again... we don't know what you've done.

I understand the links, indexes and key concepts. i'm missing the
knowlegde to to span multipletable with information related to the
same id number.

Normalize the database into more than one table would be the very first place
to start. Here's some references:

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]