By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,247 Members | 1,517 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,247 IT Pros & Developers. It's quick & easy.

Creating a Perishable Goods Database

P: 1
I am trying to create a perishible goods database. I have several items that have expiration dates and I wish to track these.

So far I have created the following tables:
Part
-contains part name and stock number

Expiration Date
-the date of expiration

Location
-where the item is located

Purchase Order
-the purchase order number that item was bought from

Now my problem that I'm having is getting access to form the relationships I need. I have same stock numbers with different expirations, same purchase orders with multiple parts. I think I am having problems with defining the proper key.
Any ideas??
Aug 15 '08 #1
Share this Question
Share on Google+
2 Replies


Expert Mod 2.5K+
P: 2,545
Hi, and Welcome to Bytes!

It isn't any help with Access you need at this stage but with relational table design and normalisation. We have an article on this very topic in our howTo section linked here.

In essence, where a table is involved in a one-many relationship the primary key from the one-side table is carried forward as a foreign (or secondary) key in the many-side table. You have none of these 'carry-forward' relationships in your tables so far.

You may also benefit from reading a good introductory text on relational database design. You can also have a look at the relationships of the sample Northwind database which is supplied with Access, as there are not that many tables in the example application and all relationships are suitably defined.

Regards

Stewart
Aug 15 '08 #2

P: 69
Apart from a very good article posted by Msquared, There's a good article on this topic in the Microsoft Knowledge Database. Search for "Understanding Relational Database Design".
Aug 16 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.