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
|
|||
|
|||
Question regarding design of tables for inventory database
I need to design a database that will track the supplies ordered from a
supplier as well as track these supplies when they a shipped to investigator sites. I would have a Suppliers table, Product Table, Investigator Sites Table, I get stuck on whether I should have a tables named Supplier Orders Table and Supplier Order Details Table as well as Site Order Table and Site Order Details. I would really appreciate any help as I'm fairly new to designing databases. Thank in advance for any help. Regards, Dee |
#2
|
|||
|
|||
Dee,
If I understand this correctly, Supplier orders are inbound, while Site orders are outbound? If that's the case, you definitely need to track both (in a header/detail two-table structure). In theory you could use common tables with just a field in the header table to differentiate between the two, but I would not recommned it. IMHO it's better to use separate tables, because you may well find, as your development progresses, that you have different needs in the data recorded for each type; a classic example is a table of suppliers tied to inbound orders, while outbound orders are tied to investigator sites (a different table). HTH, Nikos Dee wrote: I need to design a database that will track the supplies ordered from a supplier as well as track these supplies when they a shipped to investigator sites. I would have a Suppliers table, Product Table, Investigator Sites Table, I get stuck on whether I should have a tables named Supplier Orders Table and Supplier Order Details Table as well as Site Order Table and Site Order Details. I would really appreciate any help as I'm fairly new to designing databases. Thank in advance for any help. Regards, Dee |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Encrypt AccesS File? | milest | General Discussion | 2 | February 9th, 2005 07:58 PM |
Access Error Message when opening database | eah | General Discussion | 3 | January 26th, 2005 10:04 AM |
Relationship design problem with multiple tables | Don | New Users | 3 | November 24th, 2004 06:27 PM |
How do I design a database based on the information that will be stored? - Copy of Tables and hirearchies.zip (0/1) | Jim | Database Design | 1 | June 1st, 2004 01:44 PM |