need help with MSSql (newbie)

hi
im using ms sql server 2000 with the enterprise manager
i want to make a relationship between to tables.
let say first table has 2 column: ID, RegionName
the other hase 3 column: ID, employeeName, RegionName.
i want that while im trying to add new record from the enterprise manager to the second table, when i will try to assign value for the RegionName i will get a combobox with all the RegionName that the first table contains.
thanks a lot

Dovalle

in one of the tables, you will need to have an extra field, called something like tableId, in there you place the related Id from the other table.

hi,
well this is part of the way...
i did this before but then i can assign to the tableId (i added this column to the second table) only id that exists at the first table without seeing the actual name (like RegionName) and also i cant know the exsiting values let say i have only 2 records at the first table while im trying to assign value the the tableId at the second table i cant be sure which value are OK (i will get an error message but cant preliminary choose it )

thanks
Dovalle