I am again positng my problem, so that some of you can help me.
I have two tables. Table 1 has following fields: Test (primary key), TestRequirement, TestFrequency, TestOrganization. There is a associated form, Form 1
Table 2, specific record for particular test, has following fields, Test, Test Requirement, DateOfTest, PersonDone, Results, Comments. There is a associated form, Form 2
Table 1 has 1 to many relationship with Table 2. I have added a command button in form 1. I first open form 1 to see a particular test type, say Voltage test. When I click the command button, I navigate to form 2, which is specific about a particular test, say Voltage test, and the common field such as Test Type, here Voltage, Test Requirement should automatically be filled up from Table 1. But this is not happening. What I did in Form 2, for example, in 'Test' text box I have added, =[Test]![Table1]. However, when I open the Form 2 from Form 1, the 'Test' field shows #NAME?. I do not know what to do. I would appreciate any help very much to sort out the issue.
Once again thanks in advance,
I have two tables. Table 1 has following fields: Test (primary key), TestRequirement, TestFrequency, TestOrganization. There is a associated form, Form 1
Table 2, specific record for particular test, has following fields, Test, Test Requirement, DateOfTest, PersonDone, Results, Comments. There is a associated form, Form 2
Table 1 has 1 to many relationship with Table 2. I have added a command button in form 1. I first open form 1 to see a particular test type, say Voltage test. When I click the command button, I navigate to form 2, which is specific about a particular test, say Voltage test, and the common field such as Test Type, here Voltage, Test Requirement should automatically be filled up from Table 1. But this is not happening. What I did in Form 2, for example, in 'Test' text box I have added, =[Test]![Table1]. However, when I open the Form 2 from Form 1, the 'Test' field shows #NAME?. I do not know what to do. I would appreciate any help very much to sort out the issue.
Once again thanks in advance,
I figured subforms or tabs got me closer to the answer but in the end, I still have questions. I resorted to a 2 table setup to test my situation to make it as simple as possible and realized either "thats the way it is and thats the way its gonna be" or, " I need to learn how to ask questions better" 
When I add a 2nd table as a subform, I can enter data into my main form and also my subform but I have 2 navigation controls. So when I enter the 1st (of possible many records but only one per any 1 day), and am at the end of the 2nd tables (the subform) fields, it starts the next record number in that tables recordset. I want it to go back to the 1st field in the main tables recordset. And I know I can with the mouse, but it seems like I should be able to do this with code or something. If not, when the user of this database has to enter all the original records into the 2 tables on a form with a subform, it seems like its not as user friendly as it should be...
