|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
1200+ fellow developers rate and compare features of the top IDEs, like Visual Studio, Eclipse, RAD, Delphi and others, across 13 categories. Enjoy this FREE Download of the IDE User Satisfaction Study by Evans Data Corporation. Download Now!
|
|
#1
August 30th, 2003, 11:26 PM
|
|||
|
|||
Generate a consecutive key
Hi guys
I'm working in an ms-access app which has several table but just 2 are importan. These 2 tables have a pk-fk relation. My app also have 2 form (parent - child) that show date from the tables. The problem is the keys of the table. For the parent table the pk should be a consecutive integer but I dont want to allow holes in the sequence so I'm not using autonumber property. And for the child form I need the pk will be (parent pk) + a consecutive number (example: Parent Id:1 Id:2 Child IdP:1 IdC:1 IdP:1 IdC:2 IdP:1 IdC:3 IdP:2 IdC:1 IdP:2 IdC:2 Could you tell how can I do that in ms-access? Thank in advance
|
|
#2
August 31st, 2003, 08:53 AM
|
||||
|
||||
|
could you please explain why holes in the sequence would be bad
an autonumber key should be used strictly and only to tie parent-child records together, and never be visible to users of the application rudy http://r937.com/
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Generate a consecutive key |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
