I currently have 2 tables: PeopleProjectsOn Each project there are assigned multiple roles from people which are each linked columns, i.e. Role1Role2Role3Role4Role5Role6The reason I do this and not via a look up is because you can have many people wo...
yeah this is likely what I'll be moving towards, but I wanted to keep the ability to access the record from this field. With a look up I lose the ability to click on the record directly. Reason I want this is to have navigation available via the inte...
hey, thanks for the reply but not exactly what I was looking for. I would like to have a person be the record and the column to aggregate all of the projects within the 6 columns on the people table as a way to then plug into an interface down the ro...
Person TableProject TableThese are the column headers. As you can see for each project I want to break out to the different roles and the tables are linked to a many to many relationship. I would like for the 6 columns in the people table to aggregat...
