Hello,
I have a table of projects and I am trying to link some of the projects together. For example, if I am viewing project 1 on a form, I want to see projects 1a, 1b, and 1c listed as related projects. 1a, 1b, and 1c are in the same table as project 1. I also want to see 1a, 1b, and 1c listed on the form when viewing project 1. What is the best way to set up this type of relationship? And how can I enter related projects when adding a new project using a form?
I have a table of projects and I am trying to link some of the projects together. For example, if I am viewing project 1 on a form, I want to see projects 1a, 1b, and 1c listed as related projects. 1a, 1b, and 1c are in the same table as project 1. I also want to see 1a, 1b, and 1c listed on the form when viewing project 1. What is the best way to set up this type of relationship? And how can I enter related projects when adding a new project using a form?