How to link a form to existing database on another site

Users need to enter a tracking number & get status from other database

[peterdouglas]

Is there a way to put a form on my site to let users enter a tracking number and get a status update? It's for a local moving company. Right now customers go to the main, corporate site to a web page done in asp, enter their info, and get and get tracking information.

My site is designed in php (solely for the purpose of using php includes). The form on my site would have the same fields as the one on the main corporate site. Then submit info to their database and post the results on my website. Can this be done? Here are the fields:

booker ¦ sequence ¦ year
shipper's last name
origin phone number (eg:8005551212)
origin postal code (eg: M5W 3T1) (yes, it's alpha numeric)

Any suggestions or help would be greatly appreciated, thanks! :)

[moltar]

If they provide you direct access to their database, then you can just connect to it remotely. If they don't then you can scrape their results, but it's a bit unethical, unless you get an approval from the company.

[peterdouglas]

Ok, thanks. I'd like to do it the right way, but it could take them a while to get back to me. If that's the case, what sort of information would I need to look for in their source code? I'm more of a designer than a programmer, so this is a bit unfamiliar territory for me.

Thanks!