Member Avatar for abch624

Hi,

I want to implement a functionality in a database so that a menu can hold as many drinks and as many food items as possible. I am using a Link table for this functionality.

Please have a look at the link Tables.doc file attached. There is a picture (er diagram) of part of the database.

Your help might help...

Thanks - Zahid

Link_Tables.doc (32 KB)
  • 2 Contributors
  • 2 Replies
  • 108 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by abch624
Member Avatar for Ashragon

Hi Zahid,

you´re describing a One-to-Many relationship between Menu and Food/Drink.
So you have to insert the primary key from Menu as foreign key into both Food and Drink.

It should look something like this (see attachment).

Hope this helps.

Tables.jpg 15.62 KB
Member Avatar for abch624

Hi,

Thanks a lot for the reply. I understand how to do it now... PERFECT!!!!

Thanks a lot.

Hi Zahid,

you´re describing a One-to-Many relationship between Menu and Food/Drink.
So you have to insert the primary key from Menu as foreign key into both Food and Drink.

It should look something like this (see attachment).

Hope this helps.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.