Results 1 to 4 of 4
  1. #1
    IT_GIRL is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2011
    Posts
    2

    Relationships

    How do I create a one on one relationship between fields in different tables?

    For example I have a table with position numbers. Based on the position number I would like to auto-insert a job title in the job title field on a different table.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,014
    The job title is in the table with position numbers? Should not save the job title in the other table, just the record ID or position number if that is the primary key from the position table. Then when you join the tables can refer to the job title field to display in forms and reports.
    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.

  3. #3
    IT_GIRL is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2011
    Posts
    2
    THat makes sense but I can't get it to work. I guess I don't understand how to use access.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,014
    Need to understand relational database concepts, regardless of the application (SQL, Oracle, dBase). Once that is mastered, building tables according to those concepts is simple. Check this site, review the 'sticky' thread tutorials at the top of forum http://forums.aspfree.com/microsoft-access-help-18/
    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.

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

Similar Threads

  1. Relationships I think
    By darlaj5 in forum Access
    Replies: 2
    Last Post: 05-04-2011, 08:37 PM
  2. One to One Relationships
    By ketbdnetbp in forum Database Design
    Replies: 1
    Last Post: 04-27-2011, 11:22 AM
  3. Help with Many to Many Relationships
    By alpinegroove in forum Database Design
    Replies: 5
    Last Post: 03-24-2011, 01:12 PM
  4. Relationships again
    By BarbT in forum Access
    Replies: 2
    Last Post: 11-09-2010, 04:12 AM
  5. Too Many Relationships
    By MikeT in forum Database Design
    Replies: 4
    Last Post: 08-25-2010, 07:23 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 - Senior Forums