Problem #1: I have a Jobs form.  And I have a Contacts form that is linked to a contacts database.  Within the Jobs form, there are two places to look-up contacts and add them into the Jobs form.  But one of the places also allows adding a new contact.  When I add a new contact at this place it does not appear in the look-up list for the other place.  I need a field.refresh() option to refresh the look-up so I can see the new contact.  Any ideas how to accomplish?

Problem #2: I have the same Jobs form.  The Jobs form has a State field and Attachment field.  If the state changes from A -> B AND there is no attachment, then I want to block the user until he/she adds a file.  The problem is, even when I attach a file within the form, the input.Attachement field is "" (null).  I need to first submit the form, then come back and I can see the file attached.  Any ideas?

Thank you,

Erik