I have a Vendor Table and another table that has inventory related to that vendor.

How can I import the Vendor Data and associated inventory data at the same time?

This can be done, right?

Thanks

I've got the same questions, with a few additions:

My MySQL database has many tables, with many-to-one and some many-to-many relations via a connection table. There are a couple of additional index keys (like some alphabetical names, etc) that I might want to keep, but they're not crucial. The design is pretty clean...maybe not a 3NF, but a 2.8 from the Canadian judge . (Sorry)

It's easy for me to export the individual tables in either XML or CSV or SQL, using a little program called CocoaMySQL.

I haven't done any FM since the pre-relational days, so this will be my first step back in. Before I make the dive, I'd like to know which is the best path to take regarding file types, maintaining the keys, and so on. Oh, this will be FM the regular ($299) version, unless the Advanced is required.

Thanx to all....

Greetings!

Each table must be imported separately into the corresponding table in FileMaker. For a scripted import, this means using Go to Layout[] to navigate to each destination table, and using separate Import Records[] script steps for each.

The Advanced version is not required for this, but if you have a complex solution, say over 15 or 20 tables, the Advanced version is definately helpful for a number of things, including moving scripts and fields around and debugging complex scripts.