Right Outer Joins and Entering Data into query result

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Are you joining on the primary key, and enforcing referential
integrity?

Nick
 
No the populated table is a linked table from an Excel file. I have now
created a form from the populated table and insert the supplementary blank
table as a sub form and the reference field is the populated into the
supplementary table.

If I import the data and set a pk and enforce referential integrity will
this resolve it?

The query result does let me change data in the linked table whilst in the
query but the new supplementary table wont allow me to.

Thanx
BenRatty
 
Back
Top