Adding to multiple tables

[wpvnetx]

In my form I have it bringing up record information from 2 differant
tables and that works just fine. The problem is when I try to add a
new set of information it only adds the key to the one table and not
the other.

[salad]

wp*****@hotmail.com wrote:

In my form I have it bringing up record information from 2 differant
tables and that works just fine. The problem is when I try to add a
new set of information it only adds the key to the one table and not
the other.

I'll assume this is a one-to-one link, not using a subform. Let's say
the field is ID in both. Make sure the link to table2's ID is on the
form, make it invisible. In your recordsource maybe call it Table2ID.
Table2ID : Table2!ID
In the BeforeUpdate event of the form, if it's passed all of the
verification checks, then update the key. Ex:
If Cancel = False And Me.NewRecord then
Me.Table2ID = Me.ID
End If

[wpvnetx]

What is confusing me is that I have a relationship setup between the 2
tables aswell as a link between them in the query. I thought that
would be enough for it to do what I want.

[salad]

wp*****@hotmail.com wrote:

What is confusing me is that I have a relationship setup between the 2
tables aswell as a link between them in the query. I thought that
would be enough for it to do what I want.

But its obvious it isn't. Relationships between tables does not mean
each record has matching records in another table.