re: Any Microsoft Access Experts?

quote:

---

I think your design maybe part of the problem. If someone is on two teams would you want the data in both team tables right?

---

Lets start with table design. In the simplest(it's normalized but simple) form what I would do is have four tables.
PKs are bold, FKs are Italics
Alumni
Al_ID, Name, Info Fields....

Alumni_team_xref
Al_ID, Team_ID

Team_Master
Team_ID, Desc_Fields...

Competitions
Comp_ID, Team_Id, Comp_date, Detail fields...