February 11, 200322 yr 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.
February 12, 200322 yr Author 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.
Create an account or sign in to comment