On Thu, 29 Apr 2010 01:51:32 -0700 (PDT), atledreier
wrote:

I have a few tables in my database, all 1 to 1 with the master table.

That's an *extremely* unusual design. What are these tables? Why do you need
one to one relationships? Are you perhaps trying to get around the 255 field
limit? If so, you are on the wrong track!

I have a query that gather much of the data into one large
datasheet.The problem is I cannot add records through this query.
I get a message that I need a related record in the child table for it
to work.

I'm guessing that the messages is that you need a related record in the PARENT
table, not the child?

Am I right in assuming I need to add the record in the master database
first, then the inegrity check will create the record inthe child
databases, and THEN I can add data through my datasheet?

The integrity check will *prevent* the addition of an invalid record but no,
it will not automagically create a new child record.

I think you're really on the wrong track, and probably are "committing
spreadsheet". Please post a description of your tables; I'm sure there's a
better way to accomplish what you want done.
--

John W. Vinson [MVP]