I have a clinical form were all the data is bound directly to its own corresponding table. In the header of this form I have two lookup fields referncing a different table containing patient id and name: [PatientID] and [PatientName]. I would like to be able to select a patient ID# from the [PatientID] lookup field on the form and have the [PatientName] field automatically filled in with the corresponding patient name. Pretty standard stuff, but I don't know how to do it. Thanks in advance.