 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / April 2005How to keep id number though each table
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. 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.  SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html >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. What do you mean by create a form based on the second table? and vise versa > 1. Create a form based on the second table. Be sure to include the IDNumber > in the record source of the form. [quoted text clipped - 7 lines] > > get that same IdNumber into the 2nd table so I know what IdNumber the data > > goes with. 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? > 1. Create a form based on the second table. Be sure to include the IDNumber > in the record source of the form. [quoted text clipped - 7 lines] > > get that same IdNumber into the 2nd table so I know what IdNumber the data > > goes with. 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? SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html >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 [quoted text clipped - 20 lines] >> > data >> > goes with. 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. > 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? [quoted text clipped - 23 lines] > >> > data > >> > goes with. 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. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html >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 [quoted text clipped - 32 lines] >> >> > data >> >> > goes with. 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. > 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 [quoted text clipped - 36 lines] > >> >> > data > >> >> > goes with. 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? SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html > Ok, Here is what I have for each table. The first table has a field > IdNumber [quoted text clipped - 52 lines] >> >> >> > data >> >> >> > goes with. Yes you are correct on both accounts. Sorry for not getting back sooner > 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 [quoted text clipped - 56 lines] > >> >> >> > data > >> >> >> > goes with. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.