To add more,it is doing this only on certain layouts but not on all layouts.
Seems like you accidentally posted to the Go forum instead of the Pro forum--that's easy to do.
With out looking at your file, it's hard to say for sure, but two things you might want to check:
Are you exporting from a layout that lists the same records in a portal and trying to export both the records from the layout's table and the related records also?
Depending on how you've related things, that might produce what looks like the same records twice.
Are you sure you don't have duplicate records in your table?
That could also produce what looks like a double import.
Our base table is Prospects which does not have duplicates.Our Related table is ForecastFiltered_MGRREP.How can I verify if duplicates are being created in the Related table as I cannot see the data in this tableas it s not a physical table?
What is the relationship between the two (Prospects and ForecastFiltered_MGRREP)?
Do you specify any fields from ForecastFiltered_MGRREP in your export?
They are linked via the Owner_ID and MGR _Pipeline_level fields.Almost all the fields in this layout are coming from the ForecastFiltered_MGRREP.They are a few from other tables called Globals_Admin and Currency Admin.
That gives me only the vaguest idea of how you've set this up.
What table occurrence ( box in manage database relationships) is your layout based?
Exactly what options did you use when you exported the data?
From what tables did you export?
As a test, try exporting just fields from one table occurrence and see if you get any duplication.
The Table Occurence is ForecastFiltered_MGRREP
I just wanted to export all records that were displayed.
The base table is Prospect.
I have the exact same setup for USA.I am having the problem in our UK application which is setup the same as the US.
I want to atatch a document to this post.How can I do that?
You can upload to a file sharing site and then post the link to it here.
Before you do that, are you using a script to export the records or are you selecting export records from the File Menu?
I am selecting export records from the File Menu?
Which rules out scripting issues. Feel free to post a copy of your file like I described. If the data is sensitive, click on my icon and send me a private message and I'll respond with an email address if you care to use that method.