Is there a way to have form fields auto populate based on other form data already databased. Example: You have a form that captures employee(s) name, phone, fax, email, etc. You have another form to capture detailed client order information. You setup a "lookup" field to select the employee to assign that order to. You want that employee's e-mail, fax, phone to automatically become fields for that order record w/out having to select each using "lookup" function and selecting from a dropdown.
Is that possible?