Adding Records to a Different Database
I’m looping through a database (Customer) and, given a specific condition (such as Customer::Orders>10), I want to add a record to another database (BigShooter).
I then want to populate the new record with values from the current database record, as in BigShooter::Laname = Customer::Lname.
I’m not sure how to structure this in FMP. Any help to get me started is appreciated.