re: Any Microsoft Access Experts?

quote:

---

you're going to have to write a query that does this...nothing is going to just transfer over. You essentially need like a stored procedure that updates everything on a submit button or something (if I'm reading it correctly)

---

Yes when a new alumni enters his/her info and selects a team, the submit button needs to then bring up a form or make visible a panel that allows him/her to enter in multiple competitions,details for the selected team.
Then a confirm button will INSERT records(via a query that uses form values) into the appropriate tables.


eta: yea get a book.