1 to many relationship on a form

[venerable bede]

I have a 1 to many relationship between Customers and Orders.

I want to display a form which shows an order but I would also like a combo box which displays the companys. This needs to populate the foreign key of the orders table.

Can someone point me in the right direction for this.

Thanks in Advance

[ccote_1]

HI,
Try :
http://msdn.microsoft.com/library/de...netdataset.asp

or

http://msdn.microsoft.com/library/de...indowsForm.asp

Hope this helps,