Table1: Members
MembersID (autonumber), Name, Adress, etc.

Table2: Parents
ParentID (autonumber), Name, Adress, etc.

Table3: Member_Parent
MembersID, ParentID

Table1 is the recordsource for the main form and table2 for the subform on a
tab'ed control of the main form. Table3 links 1 and 2 together.

When I try to enter a new member in the main form, this is okey, but when I
try to register this new members parents in the subform Access tell's me
"Field cannot be updated". The ParentID field gives me the next number and
the record is added in Table2. Is there a way I can automaticly add the new
record in table3 and avoid the error? Is the normalisation of my tables way
out, and if so, how should it be done?

Regards
Asbj?rn S?bye

Subforms do not lend themselves naturally to many-to-many relationships,
which is presumably what you have here. I assume that your structure allows
parents to have many members, and members to have more than one parent.

In essence, you'll need one form to maintain the parents table: add new,
delete and so on; and then use a subform on the members form to manage the
_relationship_: ie adding or removing parents from a particular member. You
can open the "Create a new parent record" form using a button on the member
form, which would be convenient for your users.

Hope that helps

Tim F