How do I make a Linked Query Insertable from a Form

[EddieN1]

I have a form that I want to use to add new/change existing/delete existing Orders to an Orders table. The Orders table contains a customer number that is used to link to a Customers table. I am trying to create a maintenance form where the operator may change fields in the Orders (ship date, tax code, customer number, etc.). I want to SHOW the customer name, address, etc., but I don't want the operator to change that data. Therefore, those fields are locked. In my form's record source I have a query with the Orders linked to the Customers table. Access treats this linked query as NOT INSERTABLE and won't let me allow the operator to add new Orders. I would also like to be able to DELETE Orders without deleting the corresponding Customers.



I know there must be something simple I'm missing, but I can't find it. Please help.

Thanks, Eddie

[EddieN1]

I found my problem. I had failed to define the customer number in the Customers file as a unique index. Once I did that, it worked like it was supposed to.