Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Customers table Link Child Fields property had to be changed to ID.



    Advise no spaces or punctuation/special characters (underscore only exception) in naming convention. Better would be CustomerNum or Customer_Num, StateOrProvince, etc.

    Odd that deleting (empty?) field significantly reduced file size.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  2. #17
    Doncow is offline Novice
    Windows 8 Access 2013
    Join Date
    Oct 2014
    Posts
    16
    Thank you. I will apply the fixes to the real database and hope all works. I will let you know. Sure appreciate your advice.

  3. #18
    Doncow is offline Novice
    Windows 8 Access 2013
    Join Date
    Oct 2014
    Posts
    16
    Well, I guess I don't know what I am doing because I'm not sure what you mean by the Customers table link child fields -- where would that be? Please draw me a picture or do a screenshot of the property area you indicate. Sorry, I'm really a novice.

  4. #19
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    I never build db for users to work directly with tables so I would not even do this in table. But with table in design view, open Property Sheet popup, scroll down to the Link Child Fields property, change it to ID.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #20
    Doncow is offline Novice
    Windows 8 Access 2013
    Join Date
    Oct 2014
    Posts
    16
    Thank so much. That worked! Sorry it took so long to get back to you, but I had other work to complete. Awesome! I learned something new.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 08-05-2016, 11:53 AM
  2. Replies: 2
    Last Post: 07-27-2016, 10:25 AM
  3. Explicit Relationships and Implicit Relationships
    By Dazza666 in forum Database Design
    Replies: 2
    Last Post: 07-17-2013, 02:11 AM
  4. Connecting to a new table in the BE
    By Jamescdawson in forum Access
    Replies: 5
    Last Post: 02-06-2012, 03:57 PM
  5. connecting two tables?
    By imintrouble in forum Access
    Replies: 1
    Last Post: 01-24-2012, 02:22 PM

Tags for this Thread

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