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?
1  2539 
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*********@gma il.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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: skidvd |
last post by:
Hello:
I have just recently converted to using the InnoDB table type so that
I can enforce FOREIGN key constraints. I have been using MyISAM
tables (accessed via JDBC) successfully for some time. However, I
have just come across a problem with the new configuration that
boggles my mind....
First some configuration data:
|
by: Neil |
last post by:
I've been discussing here a SQL 7 view which scrolls slowly when linked to
an Access 2000 MDB. After trying various things, I've distilled it down to
the following: when the linked view has a virtual primary key, it is slow;
when there is no virtual primary key, it scrolls quickly.
Looking at Profiler, I see that when there is no virtual primary key, Access
sends a simple select command to SQL Server. However, when there is a
virtual...
|
by: sfh |
last post by:
Greetings all,
I have a question concerning primary key types.
In the past, I have always created tables with a primary key as an "int" such as:
CREATE TABLE color_id (
color_id int(10) unsigned NOT NULL auto_increment primary key,
color varchar(45) default NULL
) TYPE=INNODB DEFAULT CHARSET=latin1;
|
by: sfh |
last post by:
Greetings all,
(I had posted this in MS SQL on accident, my apologies :( )
I have a question concerning primary key types.
In the past, I have always created tables with a primary key as an "int" such as:
CREATE TABLE color_id (
color_id int(10) unsigned NOT NULL auto_increment primary key,
|
by: John N. |
last post by:
Hi All,
Here I have a linked list each containing a char and is double linked.
Then I have a pointer to an item in that list which is the current
insertion point.
In this funtion, the user hits the right
and left keys to move this insertion point (cursor)
Here is the problem:
| | |
by: Paul Hunter |
last post by:
I am new to databases and thus to Access. I have a situation where I am
trying to figure out how to key some tables I am working with. Consider that
I have a database of my own records which are invoices I work on. These
invoices are from four companies with their own invoice numbers. So, I
cannot key by invoice number because there is a likelihood of invoice
numbers duplicated by different companies. The records in this table of
joined...
|
by: Julia |
last post by:
I am trying to sort a linked list using insertion sort. I have seen a
lot of ways to get around this problem but no time-efficient and
space-efficient solution. This is what I have so far:
struct node
{
int x;
struct node *next;
};
|
by: veaux |
last post by:
Help! I understand how primary keys work, but may need some creative
thinking to help with this. Can't be first time it was asked.
I have a streets table with a primary key of street ID. Table is like
below:
Street ID Street Address
ID1 6 Blank Way
ID2 9 Waters Way
ID3 6 Blan Way
|
by: lochmant |
last post by:
I have a series of about 10 test databases with about 34 linked table each. I need to create an Access 2003 database front end for each of these.
I am currently trying to write a script that will allow me to link Access 2003 tables to Oracle tables. The problem is that the Oracle table that I am linking to does not have primary keys. This is a problem because when I write the VBA to link the tables, the linkes tables do not end up with...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
