I'm completely new to creating MS Access databases, so please bear with me while I ask my (probably silly) question.

I have a table for commodities that also groups them into CropGroup and Class, and every commodity would also be considered 'Any food'.

Commodity table:

I would like to add one entry (maybe in a form?), with fields like 'Country' 'Commodity' 'Metal' 'Limit' with all fields identical other than the commodity. Rather than entering these manually for each commodity, is there a way that I can specify the country, metal and limit, select 'Fruit' or 'Anyfood' to automatically create a record for each commodity associated with these terms, so it looks similar to this? Doing this would save me hours if not days of work in the long term.

Output table:

Any suggestions or pointers in the right directions would be much appreciated!

Cheers, Sophie

CodePudding user response：

You can set default value for text or comboboxes in data entry form.

So, you will set default value for each text box individually. When you you will run the form, text boxes will fill with default values automatically. If need you can then change values as per your need. As per my above screenshot, when you run the data entry form it will look like-