I'm very new to Filemaker (and scripting in general) and very much appreciate your help.
I would like users to be prompted to enter contact information for any new contacts/organizations.
When on the "Add New Contract" layout for the Contract table, users are prompted to input the name of the Contract Manager and the Organization. It should have a drop down list of the existing Organizations and Contacts, and if one already exists I would like it to display the contact info (Phone, Address, etc). But if they have to enter a new Organization or Contact, I would like them to be prompted to enter the contact information of the new organization or contact.
Does anyone have suggestions on how to accomplish this?