Dynaset (Inconsist Upd)

[Mark R]

The "prep" form's underlying Query:

Select Table.hasOnlyOneRecordawithOneFiled,
Table2.hasOnlyOneRecordwithseveralfields, Maintable.field1,
Maintable.field60etc, table4.field1, table4.field2and3,
table5.field1through8

FROM table1, table2, (table5 JOIN maintable on ID=ID)
INNER JOIN (table4 INNER JOIN (table3 INNER JOIN table2
ON table3.fieldX = table2.fieldy) [note join complexity is
aproximated here)

GROUP BY etc


I was hoping that when the data is displayed, I can update
any field from any table by setting dynaset to
Inconsistant Updates. At first it looked like it worked,
but then Iwhen I tried to close the form I got an error
message that maintablefield5 was a required field and
could not be left empty, which of course it was NOT empty.

I could just make the user open up the original entry form
and update Maintable while viewing this "prep" form.

I need guidance............the vagueness on the Join
nesting above exists because I don't fully follow the
nesting logic yet, I used wizard, so if it is critical to
your ability to advise me, bare with me and I 'll try to
provide a better skeleton.