re: Any Microsoft Access Experts?

quote:

---

My idea was to set up check boxes inside the main database form where you type in the main info, then check the boxes for the competitive team that person competed in, and then the unique ID + the first name + last name would automatically xfer to that competitive team table.

---

Use the query wizard and joining the competitive tables with the main database table only in the categories you wish to join.

Play around with that and see if it works