Need a push in the right direction.

[Erick P]

I've spent the past couple hours reading through the posts but can't figure out what I need.

I'm not a database guy, but I'm using Filemaker to solve a business problem. Currently, I have a backend mySQL database running my ordering website. That works great.

But now I need to create a set of tasks based on what products were ordered for internal processing.

So right now, using my ODBC connector, I import an exact copy of the customer table and order table from the mySQL db. So far so good.

But how do I automatically have filemaker create tasks for me to assign to my staff?

We use an application called Daylite for our day to day workflow, and I plan on importing these tasks via Applescript into Daylite. In order for this to work I'll need the Order ID# and the individual tasks all in the same table for the import to work properly.

Does that make sense? I'm new to most of this so please forgive me if I'm rambling.

Erick