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 one tables
Ok so I could use some help on table design. I am building a database that
tracks among other things "devices" on my network. A device could be a computer, printer, IP phone, etc. For each type of device there are obviously different types of information such as phone type and phone number for an IP phone and computer model, computer name, etc for a computer. My question is this: How is the best way to do this? My first impression is to do a device table for general information applicable to all "devices" and it has a one to one relationship with a "computer" table and a "IP phone" table. Is this the best way to do it, or make a single table that contains all of the details for every type of device? Assuming it is multiple one to one tables, I am guessing that for the form source, I would simply make a query that links the applicable tables together? I appreciate your guys help. Troy W. |
Thread Tools | |
Display Modes | |
|
|