How to keep id number though each table

[Guest]

I have my first table with an IdNumber as a field that is input.
Then I have another table with questions that the IdNumber answered how do I
get that same IdNumber into the 2nd table so I know what IdNumber the data
goes with.

 

[Lynn Trapp]

1. Create a form based on the second table. Be sure to include the IDNumber
in the record source of the form.
2. Create a form based on the first table, that also includes the ID number
3. Place a sub-form control on your second form and make sure the 2 forms
use the IDNumber as the Master-child link fields.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Guest]

What do you mean by create a form based on the second table? and vise versa

 

[Guest]

I made a subform on the 2nd table where i want the IDnumber to go. That
seems to be pulling the number from the 1st form. But how do I actually get
it so save in the table that is assigned to the 2nd forum?

Am I going about this the right way?
Could you give some instructions on what to do?

 

[Lynn Trapp]

Let's take a step backward. Could you post the structure of your two tables?
What relationship exists between the tables? One to Many or One to One?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Guest]

I don't have any relationships defined. I don't need any. It is just a
single entry into each table for each person. Just need the IdNumber off of
the first form to go into every Table.

 

[Lynn Trapp]

You may not have a relationship defined, but relationships have to exist (in
one form or another) to accomplish what you want. I can't help you if you
won't post your table structure.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Guest]

Ok, Here is what I have for each table. The first table has a field IdNumber
and some other fields this is the table where the IdNumber is entered and
this value has to be used in every table. All of the other tables have a
field idNum and some other fields.

So is this all that you needed? If there is anything else you need let me
know.

 

[Lynn Trapp]

So may I assume that IDNumber is the primary key for for the first table? Or
is idNum the primary key for the other tables or do you have another field
defined as the primary key?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Guest]

Yes you are correct on both accounts. Sorry for not getting back sooner