not able to edit querie

  • Thread starter Thread starter lynn atkinson
  • Start date Start date
L

lynn atkinson

I have a querie containing 3 tables. I want a field from a
4th table to be included, but as soon as I add this other
table, the querie becomes un-editable.
Does anyone have any ideas why and how I can get this
field to display?
 
lynn atkinson said:
I have a querie containing 3 tables. I want a field from a
4th table to be included, but as soon as I add this other
table, the querie becomes un-editable.
Does anyone have any ideas why and how I can get this
field to display?
Click to expand...

In order for a query to be editable the database engine must be able to
positively identify which rows in which tables the updates should be
applied to. This becomes increasingly difficult as you add more tables to
the query. There is a help topic that discusses the "When is a query
updateable?" issue that you should read as it can be a bit involved to
explain without specific knowledge of your table and query structures.

Even when editing is allowed, you run the risk that edits (particularly
deletions) will propagate to tables that you didn't intend so you must
proceed with caution. In general I avoid editing any query based on more
than a single table.
 
-----Original Message-----


In order for a query to be editable the database engine must be able to
positively identify which rows in which tables the updates should be
applied to. This becomes increasingly difficult as you add more tables to
the query. There is a help topic that discusses the "When is a query
updateable?" issue that you should read as it can be a bit involved to
explain without specific knowledge of your table and query structures.

Even when editing is allowed, you run the risk that edits (particularly
deletions) will propagate to tables that you didn't intend so you must
proceed with caution. In general I avoid editing any query based on more
than a single table.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.
Click to expand...
It is not really the querie which I need to edit. I have a
form based on the 3 tables - employee details, post
details and contract details. This works fine and
Information can be entered in to the form to update the 3
tables. However, I want the salary to be displayed in this
form too and that is the 4th table. The contract table has
a 'placement point' field which is the link field to the
salary table. WHen the 2 fields match, the salary figure
is displayed. This works wonderfully, but I now cannot
edit the form in any way.
Not sure what has gone wrong. I will read the help
document you suggest.
 
Back
Top