Right Outer Joins and Entering Data into query result

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BenRatty - 07 Sep 2006 09:24 GMT

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.

Reply to this Message

Nick 'The database Guy' - 07 Sep 2006 14:37 GMT

Are you joining on the primary key, and enforcing referential
integrity?

Nick

> 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
[quoted text clipped - 7 lines]
>
> The two tables have a right outer join of this reference number.

Reply to this Message

BenRatty - 07 Sep 2006 15:35 GMT

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

> Are you joining on the primary key, and enforcing referential
> integrity?
[quoted text clipped - 12 lines]
> >
> > The two tables have a right outer join of this reference number.

Reply to this Message