I am creating a form for class registrations.  I have one form which contains the details of the class, including drop downs for location, class type and state - and single line forms for name and other such things.  I have a second form which contains the student registration.  My goal is to connect the two forms in such a way that from the student form I can pick which class the student is attending.  My goal is that when the class name is picked the other information, from the Class form, will flow into the student record.  I have been able to make this work using a lookup field, which can connect to the single line and date fields, but it seems that the lookup field cannot connect to the Drop Down fields.  Does anyone know if this is indeed a limitation of lookup fields and if there is a work-around?