- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Any Microsoft Access Experts?
Posted on 1/17/14 at 1:25 pm to Korkstand
Posted on 1/17/14 at 1:25 pm to Korkstand
I have foreign keys set up from the unique ID key in main database to the foreign keys in each of the separate competitive team tables. The problem is that the ID never transfers when I create a new record in the main database.
And I sincerely appreciate the help, even though I might sound retarded.![](https://images.tigerdroppings.com/Images/Icons/IconLOL.gif)
And I sincerely appreciate the help, even though I might sound retarded.
![](https://images.tigerdroppings.com/Images/Icons/IconLOL.gif)
This post was edited on 1/17/14 at 1:26 pm
Posted on 1/17/14 at 1:31 pm to TheOcean
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 on 1/17/14 at 1:33 pm to TheOcean
quote:Well, the last time I touched Access was about a decade ago, so I can't be of much help there. All I can say is that it sounds like you either need to verify that an actual relationship is set up between the tables (as opposed to just having a field where the foreign key goes), or you need to check the form you have made (that's how Access works, right? You create forms within the program?
I have foreign keys set up from the unique ID key in main database to the foreign keys in each of the separate competitive team tables. The problem is that the ID never transfers when I create a new record in the main database.
![](https://images.tigerdroppings.com/Images/Icons/IconLOL.gif)
quote:No problem. And don't feel bad, I probably sound retarded to a real database guy.
And I sincerely appreciate the help, even though I might sound retarded.
![](https://images.tigerdroppings.com/Images/Icons/IconLOL.gif)
Popular
Back to top
![logo](https://images.tigerdroppings.com/images/layout/TDIcon.jpg)