I am for the first time integrating three files into one file comprising two parents, P1 and P2 and one child, C1, where the child records are displayed in a portal in P1. The key field in P1 is P1ID and C1 was set up with a key field of P1 as well in addition to is own C1ID; all are text fields and have

P1ID :: P1ID is the relationship for the portal in the original and it works fine in the original.

I brought over the layouts and turned of the auto-enter feature for the P1ID fields in the new tables prior to import to ensure that the records match the originals.

The original and new tables have the same number of records and I have paid particularly close attention to the P1IDs and their particular data and see that in each record for P1 and C1 they match the originals in random checks.

However, not all C1 files are displaying properly in the portal of P1; for example, in the integrated file, in record 1 of P1, there are 2 portal lines of data wherein the original there are, say, 4 lines, by matching P1ID's, say 27.

When I double check the C1 files I can see that there are 4 records with C1ID with 27, so I would assume all would appear, but this is not the case.

Any ideas where the import has gone wrong? Is there, perhaps an indexing issue, for example?

Thanks in advance

Developer error -- jeez.