A2K - update query needed

[Deano]

Sorry for all the questions lately (I am trying!) :)

Here's an interesting one.

I need to create 3 records on the many side of a relationship for every
record on the parent table. I'm importing some parent records and in this
case the many side will have no records so I need to fix that.

So I'm looping through the parent records, I have the PK.

I need to insert three records (I'm currently using an append query to add
the values from another table) and then fill in the null foreign key using
the parent PK.

At the moment after my append, I can't use a recordset because I've added
records without the required foreign key, so I need to do this all in one go
I think.
ta for any help

[Larry Linson]

With a few more specifics, someone might be able to suggest an approach.

How do you pick the records to copy for a record (on the "one" side) that
matches (pr provides) the foreign key?

If you'd describe what you have, and what you are trying to accomplish,
rather than how you want to implement it, we'd have more latitude in what we
might suggest.

Larry Linson
Microsoft Access MVP
"Deano" <de***@mailinator.com> wrote in message
news:43**********************@ptn-nntp-reader02.plus.net...

Sorry for all the questions lately (I am trying!) :)

Here's an interesting one.

I need to create 3 records on the many side of a relationship for every
record on the parent table. I'm importing some parent records and in this
case the many side will have no records so I need to fix that.

So I'm looping through the parent records, I have the PK.

I need to insert three records (I'm currently using an append query to add
the values from another table) and then fill in the null foreign key using
the parent PK.

At the moment after my append, I can't use a recordset because I've added
records without the required foreign key, so I need to do this all in one
go
I think.
ta for any help