G
Guest
I have two tables. One contains imported data with a unique reference number
as the primary key the other table is supplementary and has no data in it and
I have a query that returns all the fields from this table and shows blank
fields from the supplementary table. The reference number field exists in
both tables but I when I run the query I then want to the reference number
copying across from the populated table to my supplementary table and then be
able to update blank fields.
When I try I get "Cannot enter data into 'one' side of an outer join".
The two tables have a right outer join of this reference number.
as the primary key the other table is supplementary and has no data in it and
I have a query that returns all the fields from this table and shows blank
fields from the supplementary table. The reference number field exists in
both tables but I when I run the query I then want to the reference number
copying across from the populated table to my supplementary table and then be
able to update blank fields.
When I try I get "Cannot enter data into 'one' side of an outer join".
The two tables have a right outer join of this reference number.