Results 1 to 2 of 2
  1. #1
    bigdogxv is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    1

    8 Tables with Relationships

    Hello,

    I am hoping you can help me with this issue. I currently have 8 Tables that have the same set-up. Each is:



    (Table Name)_ID (Autonumber)
    (Table Name)_Requirement (Text)
    (Table Name)_Title (Memo)
    (Table Name)_Description (Memo)
    (Table Name)_Notes (Memo)

    Each requirement in a table can have a relationship with multiple requirements in any of the 7 other tables. It has been a few years since I have done this, and I am not sure where to start. My goal is to have a form where you can input a requirement from any of the Tables, and it will pull up a list of all the requirements that have a relationship to it.

    If you need an example of what I am working with, let me know. Thank you for your help!

  2. #2
    PianoMan64 is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    29
    Quote Originally Posted by bigdogxv View Post
    Hello,

    I am hoping you can help me with this issue. I currently have 8 Tables that have the same set-up. Each is:

    (Table Name)_ID (Autonumber)
    (Table Name)_Requirement (Text)
    (Table Name)_Title (Memo)
    (Table Name)_Description (Memo)
    (Table Name)_Notes (Memo)

    Each requirement in a table can have a relationship with multiple requirements in any of the 7 other tables. It has been a few years since I have done this, and I am not sure where to start. My goal is to have a form where you can input a requirement from any of the Tables, and it will pull up a list of all the requirements that have a relationship to it.

    If you need an example of what I am working with, let me know. Thank you for your help!

    I would need an example of what you're talking about. I'm not understanding how you're going to relate all the table together when you don't have a key value that they are all related to in the first place.

    Thanks,

    Joe P.

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

Similar Threads

  1. Tables Vs Relationships
    By Bruzer in forum Database Design
    Replies: 8
    Last Post: 09-06-2009, 04:39 PM
  2. Help on Tables/relationships?
    By mistaken_myst in forum Database Design
    Replies: 3
    Last Post: 04-01-2009, 05:16 PM
  3. Relationships btw tables
    By metaDM in forum Queries
    Replies: 0
    Last Post: 03-05-2009, 12:15 PM
  4. Appending Records to tables with relationships
    By RubberStamp in forum Import/Export Data
    Replies: 0
    Last Post: 12-14-2008, 06:52 AM
  5. I need help on relationships for tables.
    By justin.w in forum Access
    Replies: 0
    Last Post: 10-16-2006, 10:57 AM

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 - Senior Forums