If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
One-to-Many relationship design suggestion
I have a table called Servers with a Primary key of Server_ID; a table called
Modems with a primary key of Modem_ID, and a table called Server_HDD with a primary key of Server_HDD_ID. Both the Modems and Server_HDD tables have a Number field called Server_ID. I then have a One-to-Many relationship from the Server.server_ID to modem.server_ID, and another from server.server_ID to Server_HDD.Server_ID. The problem is when I create a query. I can add one of the tables to the query, but if I add them both, the query is blank. Can you not have two tables share the same ID in one table? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Table design help! | Niklas Östergren | General Discussion | 4 | November 5th, 2004 07:08 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Design Templates don't apply font sizes consistantly | Greg H | Powerpoint | 1 | September 15th, 2004 02:07 PM |
design master problem | J. Vermeer | General Discussion | 0 | September 8th, 2004 03:23 PM |
Table Design Suggestion | JH | Database Design | 8 | June 23rd, 2004 01:36 AM |