Editing in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a query bringing together data from two tables as I needed to
match two fields from separate tables together to bring me the related
records.

However, within this query I need to assign agents to call the related
customer mathcing both these fields and I am unable to edit this data for
some reason.

Any ideas as to how i can enable editing? I can make the drop down list pull
down but then cannot enter the data.

Many Thanks,
Matt
 
Matt said:
I have created a query bringing together data from two tables as I
needed to match two fields from separate tables together to bring me
the related records.

However, within this query I need to assign agents to call the related
customer mathcing both these fields and I am unable to edit this data
for some reason.

Any ideas as to how i can enable editing? I can make the drop down
list pull down but then cannot enter the data.

Many Thanks,
Matt
Click to expand...

There is a help topic named "When can I edit data in a query" that you need to
read. Basically multi-table queries are not editable unless constructed just
right. The more tables added the less likely that the resultset can be made
editable. With only two tables you should be able to tweak the design so that
updates are possible.
 
Rick,

I still seem to be having problems and depsite my fields not being locked it
gives this impression when attempting to edit.

All three tables have some form of join between them and still there is no
solution
Do you have any further ideas?
Matt
 
Back
Top