Started By
Message

re: Any Microsoft Access Experts?

Posted on 1/17/14 at 1:31 pm to
Posted by Doldil
The Ham
Member since Jan 2010
6214 posts
Posted on 1/17/14 at 1:31 pm to
quote:

The problem is that the ID never transfers when I create a new record in the main database.


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)
Posted by mikelbr
Baton Rouge
Member since Apr 2008
47612 posts
Posted on 1/17/14 at 1:33 pm to
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.
This post was edited on 1/17/14 at 1:35 pm
first pageprev pagePage 1 of 1Next pagelast page
refresh

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on Twitter, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookTwitterInstagram