M to N relationships

[Deeeep Mehta]

Let me introduce my problem:

- Product Master info database with a related db of attributes (1 master to N attributes)

- Quotation db which links to Product db (M quotes to 1 productmaster)

- Quotation db has its own attributes (1quote to N attributes).

Right now I lookup the attributes of the related master and export them to file and import them to quotationattributes, but this is ugly and leaves files on the client.

Productmaster has an key var ProductID

Productattrib is linked via ProductID

Quotation has a key var QuotationID and is linked to productmaster via productID

Quotationattrib is linked via QuotationID.

Is there any way I can script so that the attributes from productmaster get copied to quotationattrib?

[bruceR]

Why export-then-import? You can import directly; or you can go through a looping script and write the records.