Results 1 to 5 of 5
  1. #1
    N7925Y is offline Advanced Beginner
    Windows 10 Access 2013 32bit
    Join Date
    Apr 2016
    Posts
    32

    Populate Subform based on Form

    I have 4 tables that contain Names, Addresses, Address Codes, and Contact ID/Address ID. I have attached a pdf below to show the relationship:


    Click image for larger version. 

Name:	Database_Relationships.jpg 
Views:	17 
Size:	39.8 KB 
ID:	25965
    This issue I'm having is I want a form that contains the contacts name as well as their address. I figure I would use a bound form on contact names and a subform bound to addresses. I've tried linking through parent/child relationships but I can't get the addresses to show when i update the main form. Additionally I'd like to update the addresses in the form and have it update the respective tables. Any thoughts on how you would do it?
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In the subForm properties,
    you must fill in the LINK PARENT FIELD, and LINK CHILD FIELD.
    set both to the ContactID.

    this should sync all the addresses to the record in the parent form.

  3. #3
    N7925Y is offline Advanced Beginner
    Windows 10 Access 2013 32bit
    Join Date
    Apr 2016
    Posts
    32
    I've done that. It is not syncing. Thats my issue

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    That's how it works. It always works. If not, you have an access problem, not a user problem.
    Try repairing the database.
    try repairing Access.

  5. #5
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    I think that you have too many tables here. tbl1Contacts has an addressID, why does not that got directly to tbl2Addresses?

    What is the reason that the address is not on tbl1Contacts? The only reason would be so that you could keep multiple addresses for each contact, but then the addressID could not be stored on tbl1.

    The only reason to have multiple tables is to set up one-to-many relationships - one contact, many addresses. I don't see how tbl2ContactsAddresses is helping the database.

    Don't have spaces in table names, or field names.

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

Similar Threads

  1. Replies: 13
    Last Post: 09-10-2015, 03:37 PM
  2. Replies: 9
    Last Post: 10-16-2012, 07:51 AM
  3. Replies: 3
    Last Post: 10-03-2011, 02:33 PM
  4. Replies: 3
    Last Post: 12-06-2010, 06:35 PM
  5. Replies: 0
    Last Post: 06-23-2009, 03:01 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
  •  
Other Forums: Microsoft Office Forums