2 databases,1 query, 1 form, No edit

[SpankYou]

Hey!

I have a database (accounts package) linked via odbc to Microsoft Access. As it is a link I know you can not edit any content in the accounts package from Access (if i'm wrong please correct me ) But I have created a sub-table (in microsoft Access)that holds extra data about a particular project (Projects are held in the accounts package), that need editing.

Confused?

Basically

Accounts Package:

Project Table
(Proj_ID) (relationship with access table)
(Fields...)


Access:

Project_Table_Supplement
(Proj_ID) (Relationship with accounts)
(AmmendedDate)
(Status)

Now In A form I am producing the AmmendDate and Status need to be edited, but as the data from the accounts package cannot be edited, these seems to have caused the two access fields to behave the same. Is there anyway round this?

Thanks for any help

Sam

 

[SpankYou]

Don't Worry Sorted,

Cheers

Sam