Record Locks on form

[Sameer]

Hello everyone

We are using a SQL server backend and an access 2003 front
end for data entry purposes.

I have an Organization table, Organization_and_Category
table with Organizationid from the organization table as
foreign key and a Location table which has a foreign key
of the Organization_and_Category.

What we are trying to do is enter an Organization on a
form, then assign a Category to it in a subform (to create
the entry in Organization_and_Category table). Now from
this point we want to be able to take the id of the
organization_and_Category and open a new form or on the
current form itself be able to attach locations.

For some reasons, in access 2003, when we change already
existing organizations, the changes are recorded fine.
However when we enter a new organization it and create the
category for it and then assign a location, it says the
record is locked and you are simultaneously trying to
update. We thought this might be becuase of the fact that
the subform is open, and so we closed the main
organization form and open the locations related
information in a new form, but it still gives the same
message.

Does anybody have an idea of what the best way to do this
would be?
Any help will be appreciated.
Thanks
Sameer