Greetings! I have searched with no luck. So I will ask...

I am trying to import custom data to a relate field on Leads. In order to create the custom relate field I had to first relate the field to an existing module, then go into the php admin to change the module and table to which the field was relating to my custom module/table. This worked to add the relate field to my Edit and Detail views, but I cannot import to it. When I do the import, I see the label for the field in the dropdown, but when I map data to it (either the id as it is stored in the db, or the name as it is displayed on the form), the import completes, but the field is not populated with data (remains blank.)

I noticed that the relate fields are actually 2 fields in the db - one linked to display on the form that is null in the db, and one (that is not displayed) that actually holds the id of the related record. How can I import to this id holding field? Do I need to just import directly into SQL? I can import an assigned user by using their id, why can I not do the same with my custom field? Do I need to define the lookup array somewhere with a hack? If so, where and how?

TIA!