Instance of related records

I am looking for a solution to this problem:

I have a database which has master data for a product and a related
table with the components for that product.

Now another database creates quotations based on the master product data.

What I want to do is that when the product is selected an instance of
the product data and its components is created in the quotation
database, so that the quoter can change the specs of the product
without affecting the master data.... I got the master data copied, but
how do I get copies of the component records made?

Anyone got a decent file that does something like this to see....?

Deeeep

Re: Instance of related records

In article <47001d2d$0$24954$5f6aeac3@news.scarlet.nl>,
Deepak Mehta wrote:

> I am looking for a solution to this problem:
>
> I have a database which has master data for a product and a related
> table with the components for that product.
>
> Now another database creates quotations based on the master product data.
>
> What I want to do is that when the product is selected an instance of
> the product data and its components is created in the quotation
> database, so that the quoter can change the specs of the product
> without affecting the master data.... I got the master data copied, but
> how do I get copies of the component records made?
>
> Anyone got a decent file that does something like this to see....?
>
> Deeeep

Seems to me you would need to replicate the Product table and the
Component table in the Quotation database, then build a script that will
import the related Component data from the Master database when you
create a Product record in the Quotation database. The script would need
to preserve the relationship between Product and Components.

You would now have a replica of the original Product record and its
related component records in the Quotation database. A person can then
alter the data in that database without affecting the original master
database.

The scripted Import is the key to this.

--
For email, change to
Bill Collins