Results 1 to 2 of 2
  1. #1
    Hulkdog is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    13

    Connecting with primary keys and showing a text box returned value on form

    I have a column in access table that is a primary key with a couple other primary keys. The form I am talking about enters data into this table.



    On another table it is the sole primary key. This table is for reference purposes and contains product ID's and product names which are not duplicated.

    Can I have a text box on my form that just displays the name when I enter the product ID.

    And, what relationships do I use to get the report to also reflect this name if it cannot pull from a data field on the original table?

    Cheers,

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,182
    Is this what you're looking for?

    BaldyWeb - Autofill
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. primary/foreign keys
    By st1300 in forum Database Design
    Replies: 38
    Last Post: 12-04-2011, 01:27 PM
  2. Query using the same primary keys.
    By Franuzz in forum Queries
    Replies: 1
    Last Post: 04-11-2011, 11:27 AM
  3. Replies: 1
    Last Post: 08-03-2010, 01:33 PM
  4. Primary and Secondary Keys...
    By LittleOleMeDesigns in forum Database Design
    Replies: 5
    Last Post: 07-24-2009, 11:33 AM
  5. Are text primary keys less efficient than autonumbers?
    By bar tomas in forum Database Design
    Replies: 4
    Last Post: 05-11-2009, 09:37 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