Able to add record in table but not in form

[Bradex]

I have a tabbed form which enters data into 3 tables:

Table A: Person name and other details
Table B: Additional details of the person
Table C: Details of a specific event regarding the person which occurs daily so that each person has many ‘daily data IDs’

Table A has one-to-one relationship with Table B and one-to-many relationship with Table C.

After creating, the tables, I created the relationships with option 1 (Only include rows where the joined fields from both tables are equal) in join type. Enforce referential data integrity, cascade updating and deletion are ticked.

Then I created a tabbed form,
Page 1: Controls from Table A
Page 2: Controls from Table B
Page 3: Table C displayed as a sub-form
The Primary key is placed outside the tabbed form so that, I can know which record I am viewing regardless of the page I am on.

Now, I find that, the form displays the already existing records perfectly, but it is not allowing me to add new records. At the same time, I am able to add records from the table. I strongly feel that this has something to do with relationships.

Can somebody point out what I am doing wrong here. Thanks!

PS: One thing which I can make out is that Table A and B need not be separate. But still, I wish to know what error is occurring.

[CJ_London]

rule is one form, one table. related tables should be in subforms using the linkchild and linkmaster subform properties to create the relationship. If you have set up your relationships as one to many, these will be populated automatically

It is sometime possible to have more than one table in a form recordsource and make it updateable by changing the recordset type to dynaset - inconsistent updates, but you will need to ensure that if a new child record is created that that the relevant foreign key pointing back to the parent table is populated.

[Bradex]

You are right! ONE FORM ONE TABLE!

I combined table 1 and 2.
Then, I recreated the form and populated the fields from this new table. I added controls from table 3 as a sub-form. Now, everything works perfect!