Search results

I am creating a database to track the assignment of team members to teams. I have three tables created: TEAM, MEMBER, JNCT_TEAM_MEMBER. The team table fields are: TeamID*, TeamName, TeamPOC, POCEmail, POCNumber. The Member table fields are: MemberID*, MemberName, MemberPhone, MemberEmail The...

So, I just wanted to come back and close the loop. After restructuring everything and using junction tables, everything became VERY clear. Thanks. Although it wasn't the route I thought I needed, it was EXACTLY what I needed. You guys were a great help and I really appreciate it.

Uncle Gizmo, Thanks! I was actually laughing. And you are right, I am looking out my database structure now and trying to figure out how to re-design this so that it works with what I need. It's no secret that I am new to this and you guys have been doing it for some time, and you are surely...

Okay, I will look up a JUNCTION TABLE, but tracking completed tasks is very easy now, I simply check the "completed" checkbox in the assignments table. I have a Boolean field with a check box for that specific purpose. Unless I am overlooking something, I don't have problem tracking...

I understand, and thanks for the help. The tables have many fields, but I just wanted to keep it simple so that I could get the point across. The tasks are dynamic and they don't have a table. Instead, the name of the task is a field in the assignment table. That table contains, unique_id...

I am a little stumped on this one, have been working with Access for about 6 months now, and one of my projects has grown to a point where I need some help. I have a two tables, one is a "static" table of names. The other is a table of assignments. In my static table, there is about 100...