A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Question regarding design of tables for inventory database



 
 
Thread Tools Display Modes
  #1  
Old February 10th, 2005, 06:37 PM
Dee
external usenet poster
 
Posts: n/a
Default 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  
Old February 11th, 2005, 10:01 AM
Nikos Yannacopoulos
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Encrypt AccesS File? milest General Discussion 2 February 9th, 2005 08:58 PM
Access Error Message when opening database eah General Discussion 3 January 26th, 2005 11:04 AM
Relationship design problem with multiple tables Don New Users 3 November 24th, 2004 07: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


All times are GMT +1. The time now is 10:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.