I have a database with 2 tables "Main" and "Leads" they are related by "ID".

"Leads" is displayed in a portal on the main layout.

 

Everything works fine.

 

If I export a record you can choose the fields and the fields from the "Leads portal"

If I delete the record and then do an import to put it back all the fields show on the left (including the portal fields)

But no portal fields on the right, so the record imports back in but not the data that was in the portal fields.

 

Any ideas what I have done wrong?

 

Thanks

 

it is two separate imports to import into two tables - the first import to import the fields in the Main table, then the next import to import the fields in the Leads table. 

hth,
Martie

Hi, I can export the data from the Leads Table but When I try to import it its name is greyed out.

I believe you need to be on a layout that holds the Leads Table (not just the portal) when you import to that table

 

M