Adding multiple pieces of data to one record

[craig1988]

Hi



This is straight forward but I cant seem to ask the access community in the correct manner to get the answer I need. So, I am going to give the example of what I need.

I have a table that includes the fields; RequestID, Manager, Team, Users

The users field needs to be populated with a list of users that always changes and there is no way of knowing the number of users per request.

What is the best way to capture this scenario??

[ranman256]

still not sure what you want.
you want to add users to a team with a manager?
why does a team have users? Teams have players.

[pbaldy]

The normalized solution would be a related table with fields for RequestID and user. 5 users for a request would be 5 records in this table.

[orange]

You should review Normalization. see this link


For more Relational Design info in video form