InfoPath Dev

Hi, I need to populate a dropdown from a sharepoint list and by default the dropdown should show all the values in the list. And on selection of a value(s) in a Multiple Select List box, the values in the dropdown should show only values corresponding to the values selected in the multiple select list box.  How can I achieve ...

Thanks Clay. Would just check out the activex controls and other controls if I can make something work out like a multiple select list box. The data is getting populated from a sharepoint list and not from a table. Will check into that. Thanks a ton.

Hi, Can anybody throw some light on the use of an alternate control for Multiple Select list Box in infopath 2007, as this control is not supported in the browser compatible Infopath form. Thanks in advance, Deepa.