Need to be smarter with data import
I think I have a fundamental misunderstanding of the finer points of importing data. I am constantly frustrated when I try to automate imports of data that cross tables. For instance, if Customer A purchases Widget B and a Wufoo form provides a worksheet with the essential information, I don't know what to do.
Customers and Widgets are stored in separate tables
- Even when I succeeded in writing an elaborate script that found Cust A and stored Widg B in a related record, I was confounded if Cust A already had purchased from me (in which case Widg B replaced whatever the most recent product is that was purchased).
I have had to resort to writing a script with an external macro program that performs an elaborate copy and paste to and from each field in the Wufoo worksheet and in FM.
As you can see, I just don't get it. What am I missing?? I'm using FMPA12. Many thanks...