Results 1 to 3 of 3

Link Master Field and Link Child Field

  1. #1
    evander is offline Competent Performer
    Windows 7 Access 2003
    Join Date
    Apr 2010
    Location
    Philippines
    Posts
    193

    Post Link Master Field and Link Child Field

    The question is about master field and child field in a form-subform layout. Do the fields involved in this structure have to be actually placed on the form as textboxes (or whatever control)? Or is it enough that they are simply included in the record source of the form and subform?

    Thanks.

    -joe-

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Hi Joe,

    The Master - Child field link is held in the subform control. Usually when linking forms/subforms, you use the Primary & foreign keys from the underlying record sources to do so. (Primary key for subform, and foreign key for form.) Also, you would usually use an autonumber field as the Primary key, thus freeing you from having to manually provide a key for the record. If this is how you have set things up, then as long as the tables/queries supplying the form and subform have the linking field present, you won't need to display the field as a textbox in either the form or subform.

    Creating Subforms

    Cheers,

  3. #3
    evander is offline Competent Performer
    Windows 7 Access 2003
    Join Date
    Apr 2010
    Location
    Philippines
    Posts
    193

    Thanks Connexionlost!

    I see. Got it. So it's just optional to display the fields (fields involved in the master-child relationship) in the forms as textbox controls. Thanks for the answer!

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

Similar Threads

  1. Link Master Field Error
    By Lynn in forum Access
    Replies: 6
    Last Post: 04-11-2010, 12:00 PM
  2. Replies: 7
    Last Post: 02-08-2010, 10:14 AM
  3. Link PDF on form
    By Cae in forum Forms
    Replies: 3
    Last Post: 01-09-2010, 05:49 AM
  4. Link ComboBox to field in a table
    By DrDebate in forum Forms
    Replies: 0
    Last Post: 04-27-2007, 07:03 AM
  5. Create the link
    By accessman2 in forum Access
    Replies: 0
    Last Post: 03-12-2006, 11:16 PM

Posting Permissions

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