Results 1 to 2 of 2
  1. #1
    Harald is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Posts
    1

    Question Relations

    I am almost blank in Access. Have made a database, two tabels. "Member" and "Post". I want to use the post table for postal code and place name. So when I register a member in the Members table and the zip code, the place name will come automatically. I have zip codes as short numbers and place names as short text in the post table, but in the Member table I use relation for the place name. What am I doing wrong?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    There are several articles on Database Planning and Design at this link. I recommend that you work through 1 or 2 tutorials from RogersAccessLibrary identified in that link.
    Good luck with your project.

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

Similar Threads

  1. Relations tables
    By azhar2006 in forum Access
    Replies: 6
    Last Post: 08-03-2014, 02:29 PM
  2. Table with more relations...
    By mr3sn in forum Access
    Replies: 2
    Last Post: 02-06-2013, 02:06 AM
  3. Relations
    By Frasse in forum Database Design
    Replies: 3
    Last Post: 08-20-2012, 06:11 AM
  4. one to one relations
    By crackpot in forum Database Design
    Replies: 2
    Last Post: 08-18-2010, 09:39 AM
  5. two relations to one table?
    By kannuberg in forum Forms
    Replies: 19
    Last Post: 09-27-2009, 11:25 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