Results 1 to 5 of 5
  1. #1
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243

    Can't get tables to link properly

    Created 3 trial tables. Linked and populated the tables. Data not showing in pull down menu.
    relationships.pdf
    PopulatedTables.pdf
    DogTrial2.pdf


    accessTrial.pdf

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    the link may exist, but you haven't populated the OwnerID_FK field

  3. #3
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243
    Thank you -- I just populated that and now it works, but I guess where I started having trouble is I don't understand how I can populate that field without having to go back and manually open the other table that gives me that info. Is this the place where a lookup wizard can be applied?

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    tables are not intended for direct input of data - for that you use forms

    Note the rule for forms is one form, one table

    This demonstrates how it can be done

    1.create a main form with tbldogowners as its recordsource (this should be a single form)

    2. create another for tbldogs - would expect this to be a continuous form since one owner can have more than one dog

    3. go back to your dogowners form and insert a subform - you will be prompted for the name of the form (select dogs form) and to identify the linking fields (OwnerID and OwnerID_FK)

    job done. If you use the wizards it will take about 30 seconds - you can play with the layout once everything is working

    but it may not be how you actually want it - to do that, you need to describe your processes that result in you completing a record

    e.g. enter owner, then enter their dogs, then enter their licence

    or to update a licence - you do what? or add a new dog? what happens if an owner doesn't have license details to hand? etc

  5. #5
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243
    Thank you for your assistance. I appreciate your help.

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

Similar Threads

  1. Can't seem to join tables properly in new query
    By musicgirl in forum Queries
    Replies: 2
    Last Post: 04-05-2016, 01:48 PM
  2. Question on properly linking tables
    By wsneeden in forum Database Design
    Replies: 4
    Last Post: 04-01-2014, 01:08 PM
  3. Replies: 5
    Last Post: 03-18-2014, 06:38 AM
  4. Replies: 6
    Last Post: 06-26-2013, 08:14 AM
  5. link tables using vba
    By dumbledown in forum Import/Export Data
    Replies: 3
    Last Post: 03-09-2012, 05:27 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