nparsons75
Well-known Member
- Joined
- Sep 23, 2013
- Messages
- 1,254
- Office Version
- 2016
Hi all,
I am really looking for inspiration on how best to do something. I have a system (table) that contains records, 1 record per row.
Each record (row) represents a project.
Each project will consist of a number of project members, in this case, a maximum of 8 members.
Currently I have to have 8 columns (member 1, member 2, member 3, and so on until member 8). This not only looks untidy due to the number of columns but it also makes it difficult to report on.
For example,
I would like to know, how many projects (rows) a particular member is associated with.
Each project has an ID number in the first column. I would like to know, which ID numbers a particular member is associated with.
Having the layout of members like this makes it difficult.
I really would like to maintain the 1 row per record as this seems to make sense, however I am baffled as how I can associate a number of memebrs with each one.
Inspiration and ideas all welcome.
Thank you so much in advance.
I am really looking for inspiration on how best to do something. I have a system (table) that contains records, 1 record per row.
Each record (row) represents a project.
Each project will consist of a number of project members, in this case, a maximum of 8 members.
Currently I have to have 8 columns (member 1, member 2, member 3, and so on until member 8). This not only looks untidy due to the number of columns but it also makes it difficult to report on.
For example,
I would like to know, how many projects (rows) a particular member is associated with.
Each project has an ID number in the first column. I would like to know, which ID numbers a particular member is associated with.
Having the layout of members like this makes it difficult.
I really would like to maintain the 1 row per record as this seems to make sense, however I am baffled as how I can associate a number of memebrs with each one.
Inspiration and ideas all welcome.
Thank you so much in advance.