AnsweredAssumed Answered

Finding a potential record in unrelated table

Question asked by miw on Jan 24, 2013
Latest reply on Jan 24, 2013 by philmodjunk

Title

Finding a potential record in unrelated table

Post

     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?

Outcomes