This is difficult to explain...
I have a form that contains a subform. The problem is, in the table the records are separated, some from the main form and some from the subform. How can I get access to show the correlation of the two forms in the table?
In the main form, there are 3 controls. There is a drop-down list where an employee can select their name. The department is automated, and there's a combo box that lists projects that are associated with the department. In the subform, there is a combo list (set to continuous form mode) that shows a list of tasks associated to the projects. And finally, a text box to enter the qty of hours.
I have tables built for employees, departments, projects and tasks and all of the id's to establish their relationships. The ouput of the form points to a master table. The main form data gets put on one line and the tasks from the subform get put on another.