Import from 2 different relations

[igotit]

I've not done any importing before and I'm confused on one issue. I need to import 1000 records from a file where there are 5 fields all in the same TO (Relationship).

In my file however I have 4 fields in the Products TO and 1, VendorName in the Vendor TO. So how do I handle an import into two TO's from one?

Milo

[dreamingmind]

Milo,

You just do the two imports as you describe, however, your probably going to need some key field so you can link your two new tables together.

Possibly the one field (vendor name?) you are importing into Vendor will be the key that will connect the two tables. If so, import that field into your products table also and build the relationship to tie the products back to the vendor.

Perhaps there IS nothing you want to use as a key in the old data... In this case, you may want to create a serial field in your old data before you do the imports. Then you'll have a key field to work with.

Or the most likely case:

Maybe the old data has many products for each vendor and if you do a simple import-products and import-vendors, you'll end up with duplicate vendor records.

In this case, you could do the two imports as described in the first scenario, link on the vendor name, then clean up the vendor file to kill the duplicates.

While remaining linked on the vendor name, you could generate a new, serialized key field in vendor and send it off to a new foreign-key field in your products, then re-link the tables on this key (assuming you didn't want a name-to-name link, and I wouldn't).

Regards

Don