Ok have the following database which I'm using to basically manage my sandwich labelling.
It needs to include products, their allergens (nuts, gluten, etc) and warning message if the product might include small bones (such as in chicken or fish).
The sandwich will include details of all ingredients, whether the ingredient needs a percentage weight declared and price (possibility to support multiple pricing).
In addition to that I need the type of bread used (if any as this is not applicable to wraps or paninis).
The database is to make the data more consistent (than currently happens in excel) and easier to maintain.
The final result will be a single table which lists
sandwich code, description, type of bread, allergens, warnings & price. This is the format which our current labelling software can use.
When I was creating the Product Entry Screen it was composed of the product form and an allergen subform. I don't know how to stop the subform from allowing more than one of same allergen being added. I suspect a problem in the underlying field properties but I haven't a clue how to go about doing it.
This is my first attempt at creating a database so please forgive my stupidity.