Just joined and hope someone can help!

I have a table called TVProgrammes,
which has 10 fields, 4 of which are
foreign key Id fields to 4 other tables (Genres, Durations, Pics and BizUnits). I want the user to insert records into the database using a stored procedure (sp_InsertProgs) that I've created that links the sproc's parameters to the form's field names.

I understand how to link the sproc parameter to the empty text boxes, but I'm not sure how to get the selections made by the user for the foreign key fields (genreId, DurationsId, PicsId, BizUnitsId) into the sp_InsertProgs if I'm using stored procedures to list the options for selection from 4 different dynamic drop down menus (spListGenres, spListDurations, spListPics, spListBizUnits). I need to somehow get these four Id numbers (ie once the user selects an option from the drop down menu) into the parameters of the stored procedure so that it can update the TVProgrammes table.

Anyone know if this is possible?? And
if so, what's the secret????

Thanks everso.

Susan

Problem solved now.