Unique Table issue in Access 2000 project file

[codemech]

I have run accross an unexpected problem in a client Access 2000 project with a SQL 2000 backend.

My form recordsets only allow on table's fields to be edited when I have more than one table in the source.

For instance (just a simple example) --

I have an invoice form and I want to edit the invoice date from the invoice_header table and I want to edit a contact field from the contacts table. I get a form status message that says I need to set the unique table value. When I do this then only the unique table is editable.

I do not have this problem with an Access 2002 project file so I can work around it but I am wondering if anyone has any thoughts on this issue?

C

 

[rebooot]

Try creating a view then use your recordset for the form to access that. Hope this helps.

Rebooot