Little help in my database structure

[F0u4d]

Hello there,

I recently started learning Microsoft Access.


I'm trying to create a database for a restaurant to control the cost

What i need in my database:
- Products table for products name, id, category..
- Every product contains ingredients from ingredients table with amount of KG, G, ...
- Ingredients table contains ingredients name, id..
- Category table to put the products into categories, Sandwiches, Platters, ...

What i am stuck at is that i don't know how i can link the ingredients into products and add multiple ingredients to 1 product

I would appreciate if someone could help me in the relationships and the structure of my database

Thank you in advance

[Ruegen]

Maybe a junction table inbetween your two tables?

That way every new junction ID created can source many ingredients to one product

so ID 1 can have 2 & 1
ID 2 can have 3 & 1
ID 3 can have 4 & 1

then when you look at ID 1 (the product, you have 2,3 and 4 ingredients linked to it)

This is called a many-to-many relationship

There are others but I will wait to see what June or ItsMe say as they are better at giving advice and I'm curious with what they go with.