only first record work

[mandyang]

Hi,

P.s help!

Currently,I have 2 database.In these 2 databases,there are severals fields(repeating filed) in which I need to link together using relationship.

The problem now is:

Only the first record is working.

From record 2 onwards,the fields can't link anymore!

P/s let me know if you have any idea,why this is happening.

I'm not using portal

[Vaughan]

This is the problem with repeating fields. You're doing the right thing by going relational, but first you need to make the repeating fields relational. Split them into separate records, relating back to the master record.

The splitting itself is easy (you can export and inport) it's the "knowing where to split the records" that's a bit tricky. If you tell us some more details we may be able to help.

BTW what country are you from?