Making changes

[Tom]

I have made a Join Query that works OK. In this Query I have a column that I
use to make comments. This column is in the table used to make up this query
as well. The problem I am having is that it will not allow me to make any
changes in any column. I looked up the properties etc. and find no reason why
I can not.

Can anyone suggest what I can do?

Thanks

 

[John W. Vinson]

I have made a Join Query that works OK. In this Query I have a column that I
use to make comments. This column is in the table used to make up this query
as well. The problem I am having is that it will not allow me to make any
changes in any column. I looked up the properties etc. and find no reason why
I can not.

Can anyone suggest what I can do?

Thanks

Some queries are not updateable. For a simple two-table join like this, it
should be updateable if the join field in the "one" side table is uniquely
indexed (e.g. the Primary Key).

Perhaps you could open the query in SQL view and post the SQL text here, and
indicate which (if any) field is the Primary Key of each table (and the name
of the field you're trying to update).

 

[Tom]

I do not have a primary key. Also both tables are the same. The field I
will add notes in is "Comments" here is the Sql you requested. Thanks Tom

SELECT T1.NEW, T1.[B/L], T1.PRO, T1.CARRIER, T1.Comments, T1.SCAC, T1.[ORIG
CITY], T1.O_ST, T1.[DEST CITY], T1.D_ST, T1.[AMT PAID], T1.[SHIP DATE],
T1.[BILL DATE], T1.[CHECK DATE], T1.[SHIP WGT], T1.FS, T1.[FS AMT], T1.SO,
T1.[SO AMT], T1.[BL RGT5], T1.[BL LFT6], T1.[PRO RGT6], T1.[PRO LFT6],
T1.[FROM NAME], T1.O_ZIP, T1.[DEST NAME], T1.D_ZIP, T1.DT, T1.[DT AMT],
T1.[MS CODE], T1.[MS AMT], T1.[DH CODE], T1.[DH AMT], T1.[TC CODE], T1.[TC
AMT], T1.[HZ CODE], T1.[HZ AMT], T1.[LG CODE], T1.[LG AMT], T1.[AO CODE],
T1.[AO AMT], T1.MOVEMENT, T1.[BILL TYPE], T1.[MAJ LOC], T1.[MINOR LOC],
T1.SBU, T1.EQT, T1.SHIPPER, T1.[ORIGIN ADD], T1.[DEST ADD], T1.[MASTER B/L],
T1.[CHECK #], T1.CLASS, T1.PRODUCT, T1.TERMS, T1.[UND LH AMT], T1.[DISC AMT],
T1.[DISC %], T1.[NET LH], T1.[FS %]
FROM [NEW LAYOUT WITH BL FB ADJUSTMENTS] AS T1 INNER JOIN [NEW LAYOUT WITH
BL FB ADJUSTMENTS] AS T2 ON (T1.[B/L] = T2.[B/L]) AND (T1.PRO = T2.PRO)
WHERE (((T2.SCAC)<>[T1].[SCAC]))
ORDER BY T1.[B/L], T1.PRO;

 

[John W. Vinson]

I do not have a primary key.

Then a join will not be updateable.

Also both tables are the same.

Then it makes no sense whatsoever to have a form and subform. Just use a
textbox for the Comments field. If you need the screen real estate, put all
the other controls on one page of a tab control and the Comments textbox on
another.

Why do you feel that you need a subform????

 

[Tom]

I do not understand some of your comments. The reason for the query is when
SCAC are different one of them is wrong.
"WHERE (((T2.SCAC)<>[T1].[SCAC]))"

This allows me to determine which is wrong through some investigation and I
use the comment field to mark it, to look at further at a later time.

I suspect from what you may be saying is I need to make a primary key. But
if I have a primary key it will be in both joined tables.

Tom