Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Is it possible to copy and paste specific fields into a new table with Primary Key?
Started 4 months ago by Mythblstr
I have a table and I want to copy the Primary key, last name and first name fields but the primary key never copies over to the new table. All I get is a sequentially numbered list where I want to maintain the original Primary key IDs. Is it possible to paste the primary key field into the new table or do I have to add them individually to create a related table? Help! Using Access 2007
Site: Access World Forums  Access World Forums - site profile
Forum: Tables  Tables - forum profile
Total authors: 2 authors
Total thread posts: 4 posts
Thread activity: no new posts during last week
Domain info for: access-programmers.co.uk

Other posts in this thread:

boblarson replied 4 months ago
Why would you be copying the Key, Last Name and First Name over to a new table? Normally, you would only copy the key (into a Long Integer field) because with the key you can get the name from the other table. Storing the text of the name fields is redundant and goes against normalization principles.
Size: 302 bytes
Customize:  Customize "<b>Reply 1</b>: Is it possible to copy and paste specific fields into a new table with Primary Key? :: Tables :: Access World Forums"

Mythblstr replied 4 months ago
I'm not too much of an expert on access, but just pasting the Primary Key field will work fine. When I attempt to paste exclusively the primary key field I get the same thing, just a sequential list of numbers. So I created a new table and set the key field to "autonumber" and the field size to "long integer". Can you tell me how to create a new table that will reference specific fields from the...
Size: 487 bytes
Customize:  Customize "<b>Reply 2</b>: Is it possible to copy and paste specific fields into a new table with Primary Key? :: Tables :: Access World Forums"

boblarson replied 4 months ago
Quote: Originally Posted by Mythblstr I'm not too much of an expert on access, but just pasting the Primary Key field will work fine. When I attempt to paste exclusively the primary key field I get the same thing, just a sequential list of numbers. So I created a new table and set the key field to "autonumber" and the field size to "...
Size: 1,811 bytes
Customize:  Customize "<b>Reply 3</b>: Is it possible to copy and paste specific fields into a new table with Primary Key? :: Tables :: Access World Forums"

 

Top contributing authors

Name
Posts
Mythblstr
2
user's latest post:
Is it possible to copy and paste...
Published (2009-09-01 08:57:00)
I have a table and I want to copy the Primary key, last name and first name fields but the primary key never copies over to the new table. All I get is a sequentially numbered list where I want to maintain the original Primary key IDs. Is it possible to paste the primary key field into the new table or do I have to add them individually to create a related table? Help! Using Access 2007
boblarson
2
user's latest post:
Is it possible to copy and paste...
Published (2009-09-01 09:20:00)
Quote: Originally Posted by Mythblstr I'm not too much of an expert on access, but just pasting the Primary Key field will work fine. When I attempt to paste exclusively the primary key field I get the same thing, just a sequential list of numbers. So I created a new table and set the key field to &quot;autonumber&quot; and the field size to &quot;long integer&quot;. Can you tell me how to create a new table that will...

Related threads on "Access World Forums":

Find specific Primary Key record number? - Page 2 -...  Access World Forums - site profile Modules & VBA - forum profile Find specific Primary Key record number? - Page 2 - Access World Forums
Find specific Primary Key record number? - Page 2 - Access World Forums
Primary key from two fields  Access World Forums - site profile Queries - forum profile Primary key from two fields
Primary key from two fields
Modify all fields in the Primary Key column of a table  Access World Forums - site profile Tables - forum profile Modify all fields in the Primary Key column of a table
Modify all fields in the Primary Key column of a table
Primary Key Fields  Access World Forums - site profile General - forum profile Primary Key Fields
Primary Key Fields
Difference between candidate key and primary key?  Access World Forums - site profile Theory and practice of database design - forum profile Difference between candidate key and primary key?
Difference between candidate key and primary key?
How to stop (cancel) adding a new record  Access World Forums - site profile Forms - forum profile How to stop (cancel) adding a new record
How to stop (cancel) adding a new record
Foreign key and primary key  Access World Forums - site profile General - forum profile Foreign key and primary key
Foreign key and primary key
Foreign Key to Primary Key with two columns  Access World Forums - site profile Tables - forum profile Foreign Key to Primary Key with two columns
Foreign Key to Primary Key with two columns
Exporting specific fields to excel  Access World Forums - site profile Modules & VBA - forum profile Exporting specific fields to excel
Exporting specific fields to excel
Primary key and table name  Access World Forums - site profile Tables - forum profile Primary key and table name
Primary key and table name

Related threads on other sites:

Two fields primary key with annotations  Hibernate Forums - site profile Hibernate Annotations, EntityManager, Search, Validator, Shards - forum profile Two fields primary key with annotations
Two fields primary key with annotations
The offshore developers on my current DB2 project are...  Twitter / ebennerdotcom - site profile ebennerdotcom - forum profile The offshore developers on my current DB2 project are VARCHAR crazy: they use them for 6 character fields, primary key columns, everywhere. 11:27 AM Nov 7th from TwitterFox
The offshore developers on my current DB2 project are VARCHAR crazy: they use them for 6 character fields, primary key columns, everywhere. 11:27 AM Nov 7th from TwitterFox
Multiple fields primary key  dBforums - Database Support Community - site profile Database Concepts & Design - forum profile Multiple fields primary key
Multiple fields primary key
How to map one-to-many using multi-fields as FK  Hibernate Forums - site profile Hibernate Users - forum profile How to map one-to-many using multi-fields as FK
How to map one-to-many using multi-fields as FK
Problems with UserType for Primary Key  Hibernate Forums - site profile Hibernate Annotations, EntityManager, Search, Validator, Shards - forum profile Problems with UserType for Primary Key
Problems with UserType for Primary Key
Annotations - Relationship to non-primary unique key  Hibernate Forums - site profile Hibernate Annotations, EntityManager, Search, Validator, Shards - forum profile Annotations - Relationship to non-primary unique key
Annotations - Relationship to non-primary unique key
Automatically update fields based on data entered in...  Discussions in microsoft.public.access.gettingstarted - site profile microsoft.public.access.gettingstarted - forum profile Automatically update fields based on data entered in primary key f in microsoft.public.access.gettingstarted
Automatically update fields based on data entered in primary key f in microsoft.public.access.gettingstarted
Primary Key - Is 5 fields too much??  http://www.sql-server-performance.com - site profile General DBA Questions - forum profile Primary Key - Is 5 fields too much??
Primary Key - Is 5 fields too much??
Help: How to tell which fields are the table's primary...  eggheadcafe community - site profile SQL Server newusers - forum profile Help: How to tell which fields are the table's primary key fields?
Help: How to tell which fields are the table's primary key fields?
Thread profile page for "Is it possible to copy and paste specific fields into a new table with Primary Key?" on http://www.access-programmers.co.uk. This report page is a snippet summary view from a single thread "Is it possible to copy and paste specific fields into a new table with Primary Key?", located on the Message Board at http://www.access-programmers.co.uk. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity