Update table

[excelaron]

I have an acess 2000 database for a property legal office

There are Property managements companies that over see many properties
There are properties that sue their property management company company and then move to new company
how do I update the database to move the property to a new property management company

the database has 3 tables

Companies (property management companies)

Sites ( properties )

Status ( normalizing table for companies and sites)

I would appreciate any help since its been over 12 years since I've used access

[Sean Thomas]

Im fairly new to access myself,
However:
The companies table probably holds all the company details, each one should have a unique identity.
The sites table holds all the properties, again each one should have a unique identity.
The status table is where the 2 tie up.
you will need to change the company identity for each property on the status table

[excelaron]

I should explained in more detail

company table has Company_ID key field primary key

Site table has Company_ID - foreign key and Site_ID key fields primary key

I want to update the site to a new Company_ID

What I want to do is update the foreign key in the Site table for a certain site