look if there are already an inserted record, alternatively create a record
Hi all, I'm using filemaker pro 11.
I'm makin a db to register the departures of gifts of a company.
At each order some gifts are sent with the goods.
I want do this:
1. look if there are some gifts sent to a customer
2. if there are look the historian
3. if not create a new record with the searched code