Finding a potential record in unrelated table
I have two unrelated tables: "Contact" and "Prospect" - they are used for two distinct and separate purposes so there is no real need to link them. In my FM 12 pro database, when I type info for a contact in the Contact table, which includes a "Contact::Company" field, I would like to have the option to click a button and add that "Company" name to the Prospect table in the Prospect::Company field if that Company name does not already exist in the Prospect table. What would a script look like to have the Contact::Company first see if such a name already exists in the Prospect:Company field (presumably a find?) and then if it doesn't already exist, add it to the Prospects table?