I have been trying to manual import the data to layout with reference to multiple table. When you create a new record in FM, id and few other fields are auto created/selected.
For testing purposes, I have just tried to import 3 fields in the layout (Project name, date, contact name). Contact name is a drop down list.
On import, I am getting error. There is no specific error so it's not that helpful.
Any pointers would be much appreciated.