By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,086 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

updating primary keys in other tables automatically

P: 10
Hi, I curently have 7 tables in my db, all with the same primary key, and 1 form showing all these fields (primary key form only 1 table). Is there anyway that once a primary key has been entered on the form that it can update all the other primary keys (in this case hospital id). I need to be able to do this so that the form will show the information when i re-enter (ie all tables must have entered information for the form to appear again). Or do i need to re-organise my db? Any advice would be greatly appreciated as ive tried a few different things and not getting anywhere!!!


Oct 30 '06 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,347
If you select 'Tools / Relationships...' This will allow you to set up rules about relationships between tables.
Set up the links, play with the options, and you should have what you need.
Oct 30 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.