I have a table with vendor number and customer name.

I then have another table that lists the vendor number and all of the customer's contract numbers. I also have a year column added to the table so that I can query out only the contracts for a certain year.

The problem is that I need to connect other tables to the contract number in this query. When I do this, the fields cannot be updated.

I would like to have the following relationships.

Vendor Table connected to Conract Query by vendor number
Contract Query connect to Production Order table by contract number.

Is there a way to create relationships with a query that still allow a table to be updateable?

Thanks

There is something in the query that is preventing the query from being updatable. Are you using any aggregate functions such as Sum() or Max()? Do all the tables have properly defined primary keys? Do you have update authority to ALL tables in the query? etc.