update error

[Lez]

Hi Guys,

Access 2007 FE, SQL2005 BE

Can anyone help me with this issue, I am sure I am making a simple mistake,
but cannot see were I am going wrong.

I have an invoice form with a sub form for the line items. The line items
form has 3 tables in the query for the form

SKU_Local
VAT_Local
dbo.View_LineItems

As can be seen the first 2 tables are local tables, created when a user logs
on first thing, as these only changed on a daily basis. The
dbo.View_LineItems is linked directly to the SQL database so the items are
saved live as the order is created.

Previously I used views from the server for SKU & VAT and everything worked
ok, so to improve performance I am now saving some tables locally the
relationships are still on the same fields yet the data is now not
updateable.

Can anyone advise please

 

[Lez]

Hi Guys,

It's ok I have found the problem and it was a simple one. Just had not set
the index to the correct field when creating the link.