Query in Access cannot be updated

[Markus]

Hi folks-

this will be a piece of cake for you:

The tables
tblOne (Number, Name)
tblTwo (Number, Revenue)

are connected through a query, using one field as connector:

qryThree (Number, Name, Revenue)

The query's Name field can now not be updated. Because my knowledge
about relational databases seems to be wiped out completely, please
help me with the reason and a bypass for this problem!

Using Access XP.

Thanks mucho,

Markus

 

[Fletcher Arnold]

Hi folks-

this will be a piece of cake for you:

The tables
tblOne (Number, Name)
tblTwo (Number, Revenue)

are connected through a query, using one field as connector:

qryThree (Number, Name, Revenue)

The query's Name field can now not be updated. Because my knowledge
about relational databases seems to be wiped out completely, please
help me with the reason and a bypass for this problem!

Using Access XP.

Thanks mucho,

Markus

Just to start with, I would advise against naming fields 'Number' and
'Name' - there are times when this might cause unexpected results in Access.
It might also help have fields uniquely identified so you can distinguish
between tblOne.Number and tblTwo.Number.

Anyway, I believe your problem lies in the indexing of the tables. Is
'Number' supposed to be the primary key of tblOne and a foreign key in
tblTwo - implying a one-to-many relationship? If so you need to have
tblOne.Number marked as the primary key and tblTwo.Number indexed with
duplicates allowed.

If you have no indexing, you cannot have an updateable query.

HTH

Fletcher