Help

[Ravi]

I am connected to a SQL Server via ADP. I cannot update a
view with two tables, only one. I need to have two tables
so I can see what I am updating. Any help with being able
to update a view with two tables is greatly appreciated.
The err I get when I try is" recordset requires a form to
be updateable". When I attempt to do it through a form, I
get, "Form is read only because the unique table property
is not set".

Thanks,

Ravi

 

[Chris Strug]

Ravi,

In the form property sheet there is a property named unique table. You must
set the table you wish to update in this field.

For example, your table is based on a view showing records from an order
table and a customer table. You can only update one of these tables - you
choose which one through the "Unique Table" property.

Hope this helps.

CS