re: Any Microsoft Access Experts?

quote:

---

So the main database will have all of the alumni info tied to the unique ID. I then have completely separate tables for the the competitive teams. The only info I would like to go from the main database to the competitive teams is the unique ID and the first name + last name. That way queries will be easy to run.

---

If the first and last names are already in your main table, then you don't need to duplicate them in your team tables.

And are you making a separate table for each team? If so, you might consider making a 'teams' table that gives each team an ID (so it would just need an ID column and a name/description column), and then a table called something like 'alumni_teams' that just has two columns, one for alumni ID and one for team ID, which as someone else mentioned would just reference the foreign keys in the alumni and teams tables.