Query field won't allow insertion of data...

  • Thread starter Thread starter K Harwood
  • Start date Start date
K

K Harwood

A database that I am using (Access '97) has a simple query
using 2 related tables. When the query is opened, I wish
to fill in missing information as it arises. The field is
a text field in both the query and the table in is pulled
from. I want the information that I enter to populate the
original table. Why can't I add data? Thanks, K
 
Thanks Steve,
Here is the SQL Information:

SELECT DISTINCTROW [Final Upload 1130 Table].[Order
Catalog Description], [Final Upload 1130 Table].[HNA
Mnemonic], [Final Upload 1130 Table].PDM, Charting.[Chart
Name Classic], [Final Upload 1130 Table].[Short Name (DTA)]
FROM [Final Upload 1130 Table] LEFT JOIN Charting ON
[Final Upload 1130 Table].PDM = Charting.PDM;
I am not sure what you mean by "table structure" but
there is nothing unique about the tables. All fields are
either text or general numbers (no dates, telephone
numbers, formatted stuff). The field that is not updating
is Charting.[Chart Name Classic]. This table contain
information that is bland and it needs to populated. I
was hoping that the query would assist in this aspect.
Thanks again,
 
The table structure are the fields that comprise the table.

For example, you have a table called "Final Upload 1130 Table", and it has
the fields "PDM" and "Order Catalog Description"

So, if you'll list all of the fields to each of the tables(at least the ones
important to this problem, it may help us resolve your issue.

K Harwood said:
Thanks Steve,
Here is the SQL Information:

SELECT DISTINCTROW [Final Upload 1130 Table].[Order
Catalog Description], [Final Upload 1130 Table].[HNA
Mnemonic], [Final Upload 1130 Table].PDM, Charting.[Chart
Name Classic], [Final Upload 1130 Table].[Short Name (DTA)]
FROM [Final Upload 1130 Table] LEFT JOIN Charting ON
[Final Upload 1130 Table].PDM = Charting.PDM;
I am not sure what you mean by "table structure" but
there is nothing unique about the tables. All fields are
either text or general numbers (no dates, telephone
numbers, formatted stuff). The field that is not updating
is Charting.[Chart Name Classic]. This table contain
information that is bland and it needs to populated. I
was hoping that the query would assist in this aspect.
Thanks again,

-----Original Message-----
Unfortunately, you have not provided enough information to get an accurate
answer.

Please list your table structures, and the SQL.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-




.
Click to expand...
Click to expand...
 
I understand.
As copied from the Table design-
fieldname Data Type
(*) Id

-----Original Message-----
The table structure are the fields that comprise the table.

For example, you have a table called "Final Upload 1130 Table", and it has
the fields "PDM" and "Order Catalog Description"

So, if you'll list all of the fields to each of the tables (at least the ones
important to this problem, it may help us resolve your issue.

K Harwood said:
Thanks Steve,
Here is the SQL Information:

SELECT DISTINCTROW [Final Upload 1130 Table].[Order
Catalog Description], [Final Upload 1130 Table].[HNA
Mnemonic], [Final Upload 1130 Table].PDM, Charting. [Chart
Name Classic], [Final Upload 1130 Table].[Short Name (DTA)]
FROM [Final Upload 1130 Table] LEFT JOIN Charting ON
[Final Upload 1130 Table].PDM = Charting.PDM;
I am not sure what you mean by "table structure" but
there is nothing unique about the tables. All fields are
either text or general numbers (no dates, telephone
numbers, formatted stuff). The field that is not updating
is Charting.[Chart Name Classic]. This table contain
information that is bland and it needs to populated. I
was hoping that the query would assist in this aspect.
Thanks again,

-----Original Message-----
Unfortunately, you have not provided enough information to get an accurate
answer.

Please list your table structures, and the SQL.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

A database that I am using (Access '97) has a simple query
using 2 related tables. When the query is opened, I wish
to fill in missing information as it arises. The
Click to expand...
field
is
a text field in both the query and the table in is pulled
from. I want the information that I enter to
Click to expand...
populate
the
original table. Why can't I add data? Thanks, K


.
Click to expand...
Click to expand...


.
Click to expand...
 
I understand. As copied from the Table design- table
Final Upload 1130 Table

Field Name Data Type
(*) Id Autonumber
Order Catalog Description Text
HNA Mneumonic Text
PDM Number
Short Name (DTA) Text

Carting Table
Field Name Data Type
(*) ID Autonumber
Mneumonic Text
PDM Number
Chart name Classic Text

(*) - denotes primary key. The relationship between the
tables is direct and was created when the table was
created by Access. I hope this helps a little more.
Thanks again for your time,
Kent
-----Original Message-----
The table structure are the fields that comprise the table.

For example, you have a table called "Final Upload 1130 Table", and it has
the fields "PDM" and "Order Catalog Description"

So, if you'll list all of the fields to each of the tables (at least the ones
important to this problem, it may help us resolve your issue.

K Harwood said:
Thanks Steve,
Here is the SQL Information:

SELECT DISTINCTROW [Final Upload 1130 Table].[Order
Catalog Description], [Final Upload 1130 Table].[HNA
Mnemonic], [Final Upload 1130 Table].PDM, Charting. [Chart
Name Classic], [Final Upload 1130 Table].[Short Name (DTA)]
FROM [Final Upload 1130 Table] LEFT JOIN Charting ON
[Final Upload 1130 Table].PDM = Charting.PDM;
I am not sure what you mean by "table structure" but
there is nothing unique about the tables. All fields are
either text or general numbers (no dates, telephone
numbers, formatted stuff). The field that is not updating
is Charting.[Chart Name Classic]. This table contain
information that is bland and it needs to populated. I
was hoping that the query would assist in this aspect.
Thanks again,

-----Original Message-----
Unfortunately, you have not provided enough information to get an accurate
answer.

Please list your table structures, and the SQL.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

A database that I am using (Access '97) has a simple query
using 2 related tables. When the query is opened, I wish
to fill in missing information as it arises. The
Click to expand...
field
is
a text field in both the query and the table in is pulled
from. I want the information that I enter to
Click to expand...
populate
the
original table. Why can't I add data? Thanks, K


.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top