8 Tables with Relationships

[bigdogxv]

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!

[PianoMan64]

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.