Input data with form on join

[Freak81]

Hi,

I try to input data in table 1 with a form that is based on a join from table 1 and table 2.

I do a right join, so if there are no records for the join condition in table 1, null values are created. My idea is to change these null values, so 'real' values exist in table 1.

Can anybody help me, or show an alternative way to do this?

Thnx in advance.

Freak

 

[Pat Hartman]

Usually the best way to handle parent/child relationships is to use a main form for the parent data and a subform for the child data. You will find this structure much easier to work with.