Queries-help

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

Guest

Hi,

I have a table as namely Receipt & details. these table consist morethan 50
K rows each, & I have set unique record in receipts table & details will be
allowed to have duplicates. I have a written a query by joining this two. I
have got the details which I required, But this query doesn't allow me to
update the record as comment appears as ( recordset not updatable).

Is there any problem or lock have been done in the tables. How to invoke
this property. Pls help.

thanks in advance.

rgds,
yagna
 
hi,

Sounds like:
The table that you are updating is a linked table that does not have a
primary key or a unique index. Or, the query or the form is based on a linked
table that does not have a primary key or a unique index.

Hope this helps,
geebee
 
Back
Top