Autopopulation using macros?

[EvanRosenlieb]

I wasn't sure whether to post this under macros or forms as I believe it covers both...

I am building a database for an academic research project and am rather new to access. The specific part of the database I'm working on now deals with data that is being collected from soil samples from multiple sites across multiple times and includes two tables, a Samples table and a Cores table. The Samples table has information about the the site the sample come from and the date that it is sampled and processed. The Cores datasheet has data (Ph, moisture content, etc) about each of the six individual cores that is collected from each site. They are connected by a parent child relationship where, of course, Samples is the parent and Cores the child.

What I want to be able to do is have a form (or a collection of forms) that does the following:

1) Asks for the information about the sample (Site and Date collected)

2) Automatically creates six records in the Core datasheet with the SampleID of the Sample that was just created



3) Then pops up a second form in which that data for each of the cores can be entered.

I know how to create a simple macro that will go to another form when the current one is done. What I really want to know how to do is create six new records in the child table. Is this doable? Is there some other design that would work better?

Any help is greatly appreciated

-Evan

[June7]

I think will require VBA code to save the six records. I don't use macros but don't think can do this with one. Are you positive there will always be 6 cores? What if one is lost or damaged? Do a form/subform arrangement. As user enters each core in the subform, record is created. No code required.

[EvanRosenlieb]

Do a form/subform arrangement. As user enters each core in the subform, record is created. No code required.

Thanks I have used this approach and am having much more success with it. I have it almost all figured out however I am having one problem. The data that gets entered in the parent form shows up as a record on the parent table, and the information that gets entered into the subform gets entered as new records in the child table. However the ParentID field in the child table remains blank. I would like the ParentID field to automatically add the ParentID of the record that is being added into the child table... Surely there is a way to do this?
Thanks,
-Evan