Search:

I am not sure I understand the answer-Sorry! Each record will be for a certain mixture that contains different amounts of certain ingredients. An example would be
ID Ingred1 Rate1 Ingred2 ...

I need to create a table that has multiple columns with the same type of fields. I know that doesn't sound right, so here is an example for field names:

ID (key?)
Ingredient1
Rate1
Ingredient2...