Unable to add new rows...

[Murphy]

I have three supplier prices lists that I have in a single view using union
clauses, none of these table have primary keys as they contain blanks rows
etc, the view filters out the blank rows so that all that is left is valid
data.

I wish to join this view to a table of items stocked and display the
combined results in a view, the stocked table and the prices list view are
joined on two fields.

I can display data this way and all works well however in MS Access I am
unable to add new rows to the stocked table, if I exclude columns from the
price list view then all works well and I can add rows however I need to
display rows form this table such as price etc.

Any ideas ?

Thanks

Murphy

 

[MGFoster]

I have three supplier prices lists that I have in a single view using union
clauses, none of these table have primary keys as they contain blanks rows
etc, the view filters out the blank rows so that all that is left is valid
data.

I wish to join this view to a table of items stocked and display the
combined results in a view, the stocked table and the prices list view are
joined on two fields.

I can display data this way and all works well however in MS Access I am
unable to add new rows to the stocked table, if I exclude columns from the
price list view then all works well and I can add rows however I need to
display rows form this table such as price etc.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

UNION queries/views are not updateable. But, I suspect, that you are
using a JOIN query.

If you have a view w/ a JOIN (a JOIN is not a UNION) then you must
include all the primary key columns, unique key columns and required
columns, of the table you want to update, in the SELECT clause.

- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQGOWJoechKqOuFEgEQLS0wCgjP3JpjjVjUUpbGuhKSqcwXIB7ogAnjNC
Mh0UN/4XqFyUIZQdxbBtvqhJ
=fIyh
-----END PGP SIGNATURE-----