 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / May 2005Transfer Form Data into Table
I have a very simple database that is using three tables/three forms. All three are linked by a field called EmployeeNumber. I have two command buttons (macros which set the "EmployeeNumber" as criteria) on the bottom of form one which will take me to form two or form three. My problem is that when I enter data into form two or form three, the data does not transfer into the respective tables. Form one data dumps into its respective table just fine. I have tried adding "requery" for the two faulty forms but this does not help. How can I get the data from the two forms to propogate the fields in the two tables? >I have a very simple database that is using three tables/three forms. All >three are linked by a field called EmployeeNumber. I have two command [quoted text clipped - 5 lines] >does not help. How can I get the data from the two forms to propogate the >fields in the two tables? Whoa! Major misconceptions abound here. Storing the same data in two tables (much less three) is NEVER a good idea. Redundancy is to be avoided, thereby avoiding redundancy! Secondly, creating a record in one table will NOT automagically create a record in any other table, and it shouldn't. Different tables should contain different data, and you should only enter data into a table when there is valid data for that table. Could you explain what these three tables contain, and what you're trying to accomplish with them? I VERY strongly suspect that the problem has nothing to do with your forms, but with your table design (and perhaps your expectations of how tables and forms work). John W. Vinson[MVP] I must not have explained very well. The three tables contain different data with the exception of one field "Employee Number". What I am trying to accomplish is: there is the first form which contains information that we must store for all new employees. The second form (which has a command button link on form one) leads to a form (and table) that is specifically designed for employees who work in a lab. The third form (which has a command button link from form one) leads to a form (and table) specifically designed for employees who work in an office environment. When I enter the data on form one, it is stored in Table One. But when I enter the data in form two or three, it does not store in their respective tables. I need all of the data stored appropriately so that I can print a report for each record. > >I have a very simple database that is using three tables/three forms. All > >three are linked by a field called EmployeeNumber. I have two command [quoted text clipped - 22 lines] > > John W. Vinson[MVP] >I must not have explained very well. The three tables contain different data >with the exception of one field "Employee Number". What I am trying to [quoted text clipped - 7 lines] >form two or three, it does not store in their respective tables. I need all >of the data stored appropriately so that I can print a report for each record. I'm wondering if the second and third forms should perhaps be Subforms of the mainform, with the Employee Number as the master/child link field. It sounds like the second and third tables are in a one-to-one relationship to the Employees table (a classic case of "subclassing"). What are the Recordsource properties of the second and third form? Could you plst the code in your command button's click event? John W. Vinson[MVP] |
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.