insert into 2 tables

[justdippin]

hello i have a question that's hopefully for some of you very simple:

i have 2 tables

company with comp_id and comp_name

contact with contact_id, contact name and comp_id

when i make a new contact i need to either chose an excisting company where he works from a list, (maybe the new contact is the 2nd or 3rd contact of a company already known)

or otherwise make a new company.

Ofcourse the comp_id in the table contact is related to comp_id in the table company.

does anyone have an example or know how to do this?

thx a lot