3 table query

M

Matt Dawson

I currently have a 3 table query and need to edit within it. The only editing
i need to do is to assign a field using a drop down list box. I have joins
between the tables, yet for some reason i cannot edit still
Any ideas?
Thanks.
Matt
 
D

Duane Hookom

Are all joins based on primary and foreign keys? Can you tell us anything
about your tables or SQL?
 
M

Matt Dawson

Apologies for being brief,

My Current SQL currently only pulls certain fields from their related tables
and also has a newly created field which is an adjusted price field.

The tables are not joined by primary keys as there are not primary keys
within two of the three tables. There is no chance to. "Acceptance" is linked
to "PO" by Serial ID. "PO" is linked to "Currency" by Currency/Convert From.

Matt

Is this why I am having a problem?
 
D

Duane Hookom

If you don't have primary keys in your related/child tables, this could be
the reason you can't edit. Is there a reason you need all three tables in a
single query?
 
M

Matt Dawson

I am trying to arrange it so that I only need two relevant tables as I had
converted currency within a current 2 table query rather than creating a new
one.
Will see if this works but if not I shall come back to you
 
Top