Bruno Wolff III wrote:
On Tue, Jun 22, 2004 at 13:40:03 -0400,
Matthew Nuzum <[EMAIL PROTECTED]> wrote:
The end result is to duplicate the data for a particular record in table
"a" so that all of it's related data in tables "b" and "c" is duplicated.
Where "b" is the middle table in a many to m
Thanks for your suggestion to use curval(), that will be useful. I'd
entirely forgotten about that function. That likely will help when combined
with Richard's suggestion and an idea I already had.
I'm sorry that the problem wasn't clearer. The best way I can describe it
is like this:
The end
On Tue, Jun 22, 2004 at 12:34:35 -0400,
Matthew Nuzum <[EMAIL PROTECTED]> wrote:
> Any ideas? If someone has an alternate method of achieving the same result
> I'd be excited to hear about it.
A more precise formulation of what exactly you are doing might be helpful.
>From your description it so
Matthew Nuzum wrote:
When the relationships are one to one or one to many this process is easy,
however sometimes there's a many to many relationship.
It seems that a helpful tool would be a query that can return just the pkey
of the original record copied from and the pkey of the newly created rec
