Importing drama

[jt196]

Folks, hopefully not a big issue. I've just spent an afternoon moving contacts and accounts into the FMSP database via csv. They're separate but many of the contacts belong to companies which I've entered in as accounts. 

 

The issue is that the accounts don't show up as being connected to the contacts as I'd expect. I'm assuming it's something related to the 'relookup' command but I've tried that on both the account field in the contacts and the accounts table and it comes up with the error "There are no fields based on the field..."

 

Any hints as to how I might get this working?

[jt196]

Er, not sure if this group is very active - shall I post it to the main Q&A group?

[Richard Carlton]

You have to do two imports... or write a script to push the data from Account to contacts, etc.

 

We did shoot a video on more complex imports... because of situations like this.

 

0712 - Multi-Table Imports... Complex Imports (from the Pro 13 Video Course).