Nested one to many forms
Posted on 1997-08-09
I'm trying to put toghether a data entry form that uses nested one to many form/subforms.
The structure is Each location has many dates and each location/date has many parameters and values.
The outermost form would simply consist of location. Inside this would be a date subform and inside of this would be the list of parameters entry fields.
The idea is that you would select location then select date and then the data for that location/date would appear for entry or editing.
I've got something close to what I want. It works if all the data is entered at once, however, if data is entered at different times it doesn't save for that location/date it creates another record for that location/date.
I'm not sure if I'm explaining this very well.