•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 373,496 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,878 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser:
Views: 917 | Replies: 2
 |
•
•
Join Date: Oct 2007
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Link Tables 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
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
•
•
Join Date: Oct 2007
Location: Kiel - Germany
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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.
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.
•
•
Join Date: Oct 2007
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Re: Link Tables Hi,
Thanks a lot for the reply. I understand how to do it now... PERFECT!!!!
Thanks a lot.
Thanks a lot for the reply. I understand how to do it now... PERFECT!!!!
Thanks a lot.
•
•
•
•
Originally Posted by 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.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
Linear Mode
•
•
•
•
- Query multiple tables with duplicate data (MySQL)
- Linked SQL Server tables in MS Access (MS Access and FileMaker Pro)
- Searching for a record in multiple tables (VB.NET)
- URGENT: Implementing search with multiple dissimilar MySQL tables (MySQL)
- MySql multiple table query problem.... (MySQL)
- i have created these table can you please look at them and tell me if there are right (Visual Basic 4 / 5 / 6)
- Problem with Access Database Documenter (Windows Software)
- Error when making an event procedure in Visual Basic (C)
Other Threads in the Database Design Forum
- Previous Thread: Database Design Question
- Next Thread: Complex Database Searching...........
