I'm creating an access database for a bakery that tracks inventory and recipes. Right now they only sell x number of products but that can change in the future. The recipes range from 5 ingredients to 20+ and again, can change down the road.

I believe the best thing to do would be to create one table that holds all items for sale. Then create another table for each item with separate fields being ingredient 1, ingredient 2, etc. When...