 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / January 2005Are Primary keys needed in child tables?
Are Primary keys needed in child tables? How important is having a defined primary key in child tables? Here is my dilemma; I have 35 groups running around come desert country. I having them send updates to a central database with something like XML files (I haven’t exactly figured out how yet). The primary table won’t have any conflicts, but I am contimpated the need to have primary keys in the child tables. Could you guys let me know what you think and if it’s worth combining a group ID with an Auto number in the forms (or if there is some way to have the Jet do it maybe by default?) >Are Primary keys needed in child tables? Primary keys are needed in ALL tables. >How important is having a defined primary key in child tables? Essential, if you want to update the table, delete records, sort, .... >Here is my dilemma; I have 35 groups running around come desert country. I >having them send updates to a central database with something like XML files [quoted text clipped - 6 lines] >group ID with an Auto number in the forms (or if there is some way to have >the Jet do it maybe by default?) Two suggestions: use a two-field primary key consisting of the groupID and a Long Integer sequential number, probably manually assigned (though an autonumber should work); or use Access Replication, if you are bold, undaunted by code, and willing to read up on this complex subject <g>. John W. Vinson[MVP] John, Thanks for the Advice, on both topics, sorry it took me so long to reply. I ended up combining the group id and the auto number. I was just relunctent to do that because i am curious, can i import data without making code to import it. or pretty much to i need to make some code or query instead up derectly importing data? Once again, Thanks! > >Are Primary keys needed in child tables? > [quoted text clipped - 22 lines] > > John W. Vinson[MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.