I am a relative novice at database construction and new to this forum.
I have set up a database to manage the crop records on my farm. The main table is 'Fields'(the agricultural sort!) with child tables, 'Cropping' and 'Cultivations'. I have embedded browses for 'Cropping' and 'Cultivations' on my main 'Field' form, joined by 'field_name' and 'harvest_year'. I also have an embedded browse listing all the Field (agricultural) names so that I can jump easily between Fields. All this works fine.
I now want to set up another embedded browse so that I can batch enter (say) cultivations. We frequently perform the same cultivation on a number of Fields which I can enter by going to each Field(agric) in turn. This can get long winded. I have a 'select_box' field (non-agric.!) to make a selection of Fields and I would now like a one-click way of creating a new record in the 'Cultivations' table for each of my chosen Fields (agric.). I realise that this new embedded browse must have a different join to the other 'Cultivations' browse (see paragraph above) and I think a join on 'harvest_year' alone may work. But I can't fathom a way of then automatically creating the new records in this browse.
My expertise is limited to action scripting and even that is pretty thin.
I think this is probably as clear as mud, with the confusion of Fields and fields, but I am hoping someone can help.
Happy Christmas.
I have set up a database to manage the crop records on my farm. The main table is 'Fields'(the agricultural sort!) with child tables, 'Cropping' and 'Cultivations'. I have embedded browses for 'Cropping' and 'Cultivations' on my main 'Field' form, joined by 'field_name' and 'harvest_year'. I also have an embedded browse listing all the Field (agricultural) names so that I can jump easily between Fields. All this works fine.
I now want to set up another embedded browse so that I can batch enter (say) cultivations. We frequently perform the same cultivation on a number of Fields which I can enter by going to each Field(agric) in turn. This can get long winded. I have a 'select_box' field (non-agric.!) to make a selection of Fields and I would now like a one-click way of creating a new record in the 'Cultivations' table for each of my chosen Fields (agric.). I realise that this new embedded browse must have a different join to the other 'Cultivations' browse (see paragraph above) and I think a join on 'harvest_year' alone may work. But I can't fathom a way of then automatically creating the new records in this browse.
My expertise is limited to action scripting and even that is pretty thin.
I think this is probably as clear as mud, with the confusion of Fields and fields, but I am hoping someone can help.
Happy Christmas.
Comment