Results 1 to 2 of 2
  1. #1
    chrisbas is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2012
    Posts
    1

    Primary Key and Foreign Key Question

    Hello, thanks in advance for any help. I have been given the unfortunate task of creating a database for a restaurant. I understand the form concept of being able to have the primary key and foreign key data entered simualtaneously through forms. However, I am entering alot of previous data into the database first without the use of forms. I have a table called Products wityh 145 records that lists all the products with there suppliers and product code and quantity per unit....etc. I then created a table called Inventory that containts on hand and cost fields. The products table has a primary key ProductID set to autonumber, the Inventory table has a foreign key name ProductID set to number. I linked the primary key to the foreign key in the relationships layout. My question is how do i make the productID of Products table autofill the Inventory's foreign key without having to copy and paste?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,321
    I have been given the unfortunate task of creating a database for a restaurant.
    This says it all to me. Get a handle on the basics and concepts before you waste a lot of time.

    Here is a list of free video tutorials all about database concepts

    Normalization, Entity Relationship Diagramming, Relationships, Cardinality....

    The videos deal with a Customer, Order , OrderDetails, Items theme.

    Watch them, and re-watch as necessary to get a foundation in the underlying concepts.

    Then come back with questions and a first cut ERD.

    There are other videos, but this group is by the same presenter and covers an example situation.

    http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

    http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

    http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

    http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

    http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

    http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

    http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

    http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

    http://www.youtube.com/watch?v=lXAGQ8vmhCY ERD Part 2

    The first few topics at this site are well worth the read.

    http://www.rogersaccesslibrary.com/forum/topic238.html

    Good luck with your project.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 04-16-2012, 08:34 AM
  2. primary/foreign keys
    By st1300 in forum Database Design
    Replies: 38
    Last Post: 12-04-2011, 01:27 PM
  3. Primary and foreign key in relationships?
    By Fatbot in forum Access
    Replies: 1
    Last Post: 04-12-2011, 10:11 AM
  4. import the foreign key into the primary key
    By vCallNSPF in forum Forms
    Replies: 3
    Last Post: 01-14-2010, 06:51 PM
  5. Primary/foreign keys + relationships
    By tripptofer in forum Database Design
    Replies: 0
    Last Post: 08-12-2009, 07:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums