Fw: Database Insert Help

Hi, I need some help with an insert issue.

I have two tables, organizations and contacts.
Every contact relates back to an organization

Organizations has org_id, org_name, and org_address, etc
Contacts has contact_id, contact_name, contact_address and a foreign key
called c_org_id.

contact_id and org_id are both auto increment integers.

I would like to set it up, via a web page, or a third party control, so that
when a user is adding new contact information,
they don't have to know which number to enter to relate back to an
organization, but instead could just pull down the organizations name from a
list box. Behind the scenes, that would be associated with the
organization's unique id and that would be entered into the table.

Can someone show me an example of how to do this in mysql? Since this will
be on a web page, I can combine with perl to make this easier to do. And
please, the more detailed and explicit the better.

Thank you,
Taylor
>


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org