Looking up fields from other tables

[crazymarvin]

Hey, I have two tables, one with order information and another with client details. The primary key in each of them is a 'ClientID' field. As well as the two tables, I have forms letting you enter data into each table. On the booking form i want to be able to look up the Client ID based on a customers surname. Can I do this?

 

[pbaldy]

Sure; try the combo box wizard.