I have created a form that contains information on a new product design. The main form has things like material, what equipment will make, who the designer is ...
It has a relationship to a subform that tracks each time we try to produce it, information like trial number, trail date started, trial date stopped, trial tool number...
What I want is to be able to get data from a specific subform record that meets a condition. There is a start date and stop date for each record in the subform. I want to build a query that will show me each new product design record (main form) and the start date from the record in the subform that does not have a stop date. This way I can see how long the current trial is taking for each main form record.
Any thoughts?