Create new record in a different database first

[phatphish]

Perhaps this is a bit tedious, but I hope someone can help me out...

I have a Tasks DB on a macosx and a Projects DB on a PC. One project can have many tasks (1-to-many relationship). No new task can be added unless a new project is created first (or already existed). And there's a Proj_ID field in Tasks that links to Projects.

I've created a web form so web users can enter new tasks.

However, is there a way to automate everything (add new record in Projects first, then pass the new Proj_ID to Tasks and add user's data)? Do I need to use ScriptMaker? Or PHP will suffice? If so, how do I go about writing the code?

Thanks a lot.

[Anatoli]

Use CDML and InLine.

How did you enable the databases for Web?

[phatphish]

Oh I just figured it out... Using CGI requests to trigger a script in the Projects DB to add a new record.

BTW I'm using PHP and XML-RPC.