Hi everyone,
Before I ask my question, the following is a bit of context.
I'm tasked with creating a database that tracks the testing of samples (tasks) in the QC lab of a factory. The overall database will be managing the availability of lab analysts, analytical methods, test records, equipment availability, etc. A big one.
But first, I'm trying to create a form where the lab planner can create task.
This is rather straightforward. A table with Task_ID as primary, Analyst_ID, instrument_ID Test_method_ID as foreign keys and a date field and a text field for remarks.
The twist comes here. Some (but not all) tasks actually comes in 2 parts - Part A and Part B. Most of the information for both Tasks A & B will be same except for different dates (B takes place several days after A).
Now, how can I create a form that allows me to generate 2 records at once, with only different dates?
I have attached an example of what I think can achieve this. There is a Table with ID as primary and 2 fields, Info1 and Info2. In my input form, I have created 2 subforms, Table1 Left subform and Table1 Right subform. My plan is that my user can fill up Info1 field in the Left subform and it will auto-populate the corresponding Info1 field in the Right subform. Info2 would represent the dates which are meant to be different for A & B. When i close the form, 2 records will be created. Viola! Or so I thought.
Right now, I can't get the textbox for Info1 in the Right subform to "pull" the information typed in the textbox for Info1 in the Left subform. How can I make this happen.
Or is there a better way to implement this?
Thanks in advance!
Before I ask my question, the following is a bit of context.
I'm tasked with creating a database that tracks the testing of samples (tasks) in the QC lab of a factory. The overall database will be managing the availability of lab analysts, analytical methods, test records, equipment availability, etc. A big one.
But first, I'm trying to create a form where the lab planner can create task.
This is rather straightforward. A table with Task_ID as primary, Analyst_ID, instrument_ID Test_method_ID as foreign keys and a date field and a text field for remarks.
The twist comes here. Some (but not all) tasks actually comes in 2 parts - Part A and Part B. Most of the information for both Tasks A & B will be same except for different dates (B takes place several days after A).
Now, how can I create a form that allows me to generate 2 records at once, with only different dates?
I have attached an example of what I think can achieve this. There is a Table with ID as primary and 2 fields, Info1 and Info2. In my input form, I have created 2 subforms, Table1 Left subform and Table1 Right subform. My plan is that my user can fill up Info1 field in the Left subform and it will auto-populate the corresponding Info1 field in the Right subform. Info2 would represent the dates which are meant to be different for A & B. When i close the form, 2 records will be created. Viola! Or so I thought.
Right now, I can't get the textbox for Info1 in the Right subform to "pull" the information typed in the textbox for Info1 in the Left subform. How can I make this happen.
Or is there a better way to implement this?
Thanks in advance!