If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Are 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?) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
junction tables for 3 many to many relationships | LAF | Database Design | 17 | January 5th, 2005 04:01 PM |
Updating primary key in related tables? | Matt | General Discussion | 1 | September 9th, 2004 05:22 PM |
Using Primary Keys | Jodie | General Discussion | 1 | July 14th, 2004 08:49 PM |
Mutliple Tables lookup? | Westley | Database Design | 4 | June 15th, 2004 01:07 AM |