I have 2 tables, CASE and ISSUE. My table, CASE, stores the issues
pertaining to that particular case. The table, CASE, was designed with
2 fields, IssueID and IssueDesc. Right now, all of the issues are
stord in the field, IssueDesc. BUT I'd like to change that so that the
issues are stored in the IssueID field.
On my form, the "Control Source" was linked to IssueDesc. So, the
issues the user selected are stored in the field, IssueDesc, in the
table, CASE.
Please see the Example below.
*************** *************** *******
Table: ISSUE
IssueID = Primary Key
IssueDesc (Text)
*************** *************** *******
Example of ISSUE Table:
IssueID IssueDesc
1 Age
2 Sexual Harassment
3 Termination
*************** *************** *******
Table: CASE
CaseID = Primary Key
IssueID (Number)
IssueDesc (Text)
*************** *************** *******
Example of CASE Table:
CaseID IssueID IssueDesc
200 0 Age
300 0 Sexual Harassment
400 0 Termination
*************** *************** *******
Do you see how there are "0's" in the IssueID field in CASE? That's
because the "Control Source" on the form was linked to that field.
I would like to get rid of the IssueDesc field from the table, CASE,
and only store the user's selection in IssueID.
Is there any way to match the correct IssueID with that matching
IssueDesc in my table, CASE? Or will I have to go back and re-select
the issue so that IssueID is stored?
Thanks soo much!
Megan
1  2052 
Assuming your IssueDesc field values are the same in both tables you
can use an SQL update statement on a join of the two tables:
UPDATE Issue RIGHT JOIN Case ON Issue.IssueDesc = Case.IssueDesc SET
Case.IssueID = Issue.IssueID;
That should update all IssueID fields in the Case table and then you
can safely drop the IssueDesc field. HTH
Rick Collard www.msc-lims.com
On 30 Apr 2004 10:55:30 -0700, me************* *@hotmail.com (Megan)
wrote: I have 2 tables, CASE and ISSUE. My table, CASE, stores the issues
pertaining to that particular case. The table, CASE, was designed with
2 fields, IssueID and IssueDesc. Right now, all of the issues are
stord in the field, IssueDesc. BUT I'd like to change that so that the
issues are stored in the IssueID field.
On my form, the "Control Source" was linked to IssueDesc. So, the
issues the user selected are stored in the field, IssueDesc, in the
table, CASE.
Please see the Example below.
************** *************** ********
Table: ISSUE
IssueID = Primary Key
IssueDesc (Text)
************** *************** ********
Example of ISSUE Table:
IssueID IssueDesc
1 Age
2 Sexual Harassment
3 Termination
************** *************** ********
Table: CASE
CaseID = Primary Key
IssueID (Number)
IssueDesc (Text)
************** *************** ********
Example of CASE Table:
CaseID IssueID IssueDesc
200 0 Age
300 0 Sexual Harassment
400 0 Termination
************** *************** ********
Do you see how there are "0's" in the IssueID field in CASE? That's
because the "Control Source" on the form was linked to that field.
I would like to get rid of the IssueDesc field from the table, CASE,
and only store the user's selection in IssueID.
Is there any way to match the correct IssueID with that matching
IssueDesc in my table, CASE? Or will I have to go back and re-select
the issue so that IssueID is stored?
Thanks soo much!
Megan This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: baustin75 |
last post by:
Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie
only when debugging in php designer 2005
--------------------------------------------------------------------------------
Hello,
I have a very simple problem but cannot seem to figure it out. I have a
very simple php script that sends a test email to myself. When I debug
it in PHP designer, it works with no problems, I get the test email. If
|
by: Edward S |
last post by:
I budget for a Project in an Excel sheet as illustrated below. The
months below are usually a 2 year period i.e. 24 months, though it
could be over 24 months depending upon a Project. I then need to
input this in an Access database, where I do a comparison with the
Actual cost. The table “TblBudget” in Access is made of 4
fields, namely: (1) CostElement (2) CostCenter (3) Month (4) Amount$.
At the moment this method is very cumbersome....
|
by: Megan |
last post by:
I have 2 tables, CASE and ISSUE. My table, CASE, stores the issues
pertaining to that particular case. The table, CASE, was designed with
2 fields, IssueID and IssueDesc. Right now, all of the issues are
stord in the field, IssueDesc. BUT I'd like to change that so that the
issues are stored in the IssueID field.
On my form, the "Control Source" was linked to IssueDesc. So, the
issues the user selected are stored in the field, IssueDesc,...
|
by: Siv |
last post by:
Hi,
If I run the following:
strSQL = "Select * FROM Clients;"
da = New OleDb.OleDbDataAdapter(strSQL, Conn) 'Create data adapter
cb = New OleDb.OleDbCommandBuilder(da) 'Create command builder using the datadapter
dt = New Data.DataTable
da.Fill(dt) 'pour in the data using the adapter
|
by: Rahul |
last post by:
Hi Everybody
I have some problem in my script. please help me. This is script file.
I have one *.inq file. I want run this script in XML files. But this
script errors shows . If u want i am attach this script
files and inq files. I cant understand this error. Please suggest me.
You can talk with my yahoo id b_sahoo1@yahoo.com. Now i am online.
Plz....Plz..Plz...
| | |
by: treelife |
last post by:
I'm getting and internal server error when | run the following
mod_python script. I am actually trying to run Django.
Script:
from mod_python import apache
def handler(req):
req.content_type = 'text/plain'
req.write("Under Construction")
|
by: |
last post by:
The problem lies here eval("document.TeeForm.amt.value(S+M)");
S and M suppose to add up and the total suppose to appear on the AMT field
but it didn't. Any help?
============================ CODE
==============================================
|
by: Jacob.Bruxer |
last post by:
Hi,
I'm pretty new to Visual Basic and was wondering if anyone could give
some general advise on how to conserve memory when running a Visual
Basic program that I've created. I keep getting a "Win32 exception was
unhandled" error, and I'm pretty sure resource usage is the problem.
This might be way too general of a question, so I'll try to explain
what it is I'm trying to do as briefly as I can.
Basically, my program reads a text file...
|
by: John |
last post by:
Hi Everyone,
I have a question about dynamically changing the length of a varchar(n)
field, in case the value I'm trying to insert is too big and will give
a "truncated" error, but before the error is given! i.e. Is there some
kind of a way to "test" the length of the field while Inserting the
value into it, and to have it automatically increase its length to the
length of the value being inserted, in case the value is too big?
I've...
|
by: sorobor |
last post by:
dear sir ..
i am using cakephp freamwork ..By the way i m begener in php and javascript ..
My probs r bellow
I made a javascript calender ..there is a close button ..when i press close button then the calender gone actually i want if i click outside off the calender then it should me removed ..How kan i do this ...
Pls inform me as early as possible ..
I am waiting for ur quick replay ...Here i attached the source code ....
<!DOCTYPE...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: 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...
| |
