Form is locked, can only enter data on the table

[Guest]

I have two tables, Security Data (SSN is Pkey) and SIR table (SIRid is Pkey).
I have them joined on SSN (one to many relationship, joined on many SIRs to
one SSN #3).

I have a form (SIR) based on a query gathering data from both tables. I
want to create an SIR for a certain record (SSN) that already exists. As
soon as I enter the SSN and name on my SIR form, all the other fields lock
up. It says that the SSN entered already exists. I know it does! I only
want to add more info. to that record.

So I cannot enter new SIRs on my form. The funny thing is that I can enter
data (new SIRs) on my SIR table.

Can anyone please HELP?
ynj

 

[Guest]

You have to change the input query on the form so that it uses SIR table for
record operations.

 

[Guest]

OK, I did what you suggested and it worked. Thank you! I've also changed my
relationship to join the tables w/an ID instead of using SSN to link.

The new problem I have is now that I can enter new data on the forms (SIR),
I'm not able to delete it. I can't even delete from the SIR table. The
error I get says that multi-users are using it and that the record is
currently being updated by another person. I know it's not true because only
certain people have access and no one was using it at the time of deletion.

What do you think?

 

[Guest]

Delete the relationships. You should have the following table structure.

SIN

Key
Field-1
Field-2
Field-N

SIR
SIN-Key (Same Name and DataType)
Key
Field-1
Field-2
Field-N

Recreate the relationship between the SIN and SIR tables relating the key of
SIN to the SIN-Key of the SIR table and check Enforce Referential Integrity
in the dialog box.

Now design the form using a child form to enter data of SIR. Check the
properties of both forms for allowed operations.

Are you using Access Project or Access in a networked environment.