primary key questions 
Author Message
 primary key questions

Using VB4.0 16-bit on Win95:
I use Data Manager to create a simple
database & table.  I only want a 10-char
text field (code) and a 40-char text field
as description.  I want the code field to
be the "primary" key and the only index.
When I go into design mode and click "Keys"
and select Primary, then select the code
field, it turns my 10/text field (code) into
a long/counter field!  My code field will
be required and will be unique, so why won't
it let me use it as the primary key without
making it a long/counter?  Is this just
the DM (should I use Access to do this instead?).
Also, what is the purpose of the "Primary Key"?
I defined my code field to be the key of an
index and everything seems to work fine, so why
would I need to define the primary key anyway?

I'm new to VB to please be gentle and spare me
any flammage (I'm outta asbestos undies :-))
if this is a basic issue.  Also, please feel free
to point to a reference in the manuals as I have
no problem doing my own homework.  

Many thanks in advance
/dlj
David L Jarvis



Sat, 16 May 1998 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Jet primary key question

2. Tables and Primary Keys Question

3. DB design and primary key question

4. Joined Primary Key in Foxpro (Make 1 Primary Key from 2 fields)

5. ADO and Access Primary Key Open Question????????

6. Primary key is a combination of two keys

7. Primary key is a combination of two keys

8. Primary key , Secondary Key ???????

9. Primary key is a combination of two keys

10. Primary key, Foreign key, referential integrity, etc?

11. Using SQL to create 2 Primary/Unique Keys in a Table

12. Primary Key Disappears

 

 
Powered by phpBB® Forum Software