By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,041 Members | 1,734 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,041 IT Pros & Developers. It's quick & easy.

Primary key insertion/sorting of linked tables

P: n/a
I have 2 linked tables,

The first table (PRODUCT) has product name, pricing, size, etc with an
autonumber primary key.

The second table is a UPC table with the primary key from PRODUCT
linked to a UNIQUE UPC. Youcan have multiple UPC's to each primary key
from product.

I need to sort PRODUCT so that it is sorted by product name, while also
reassigning the primary keys so that both the primary key autonumber
row as well as the product name row is sorted. This will mess up the
UPC table though...

is there any easy way to do this instead of recreating the tables?

Aug 17 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Do you want your new Product table to have the primary key of the first
product alphabetically assigned 1 and the next assigned 2, etc. If this is
the case, don't do it. The primary key is fulfilling its function of
associating the product to the UPC(s). You can always sort in a query anyway
you want as that is a basic function of a query. Use tables to store data,
queries to manipulate that data, forms to enter and present data and reports
to present data.

Je*********@gmail.com wrote:
>I have 2 linked tables,

The first table (PRODUCT) has product name, pricing, size, etc with an
autonumber primary key.

The second table is a UPC table with the primary key from PRODUCT
linked to a UNIQUE UPC. Youcan have multiple UPC's to each primary key
from product.

I need to sort PRODUCT so that it is sorted by product name, while also
reassigning the primary keys so that both the primary key autonumber
row as well as the product name row is sorted. This will mess up the
UPC table though...

is there any easy way to do this instead of recreating the tables?
--
Message posted via http://www.accessmonster.com

Aug 17 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.