I basically exported the most important records and relationships from an old COBOL database into a tab delimited file using a set of perl scripts.

The data imports into the FM database just fine, however, some small glitches seem to show up here and there.

The most annoying so far is that value list fields that draw on a simple join table relationship shows until I actually go to the layout which shows shows that the relationship exists via portal. Then when I return to the other layout which hosts the value lists, suddenly the list is populated just fine.

Am I missing a step? Do I have to reindex or something when importing huge amounts of data?

So I guess nobody has any idea.

I know what you're all probably thinking. You're thinking "well that sounds like bad data" since I used the words "COBOL" and "perl" and "import" in the same sentence.

Being that all my portals, reports, and everything else work correctly, I am not inclined to believe this is bad data. Only the value list MENUS don't work until I go to a record and "touch" the data relationship through a portal, THEN the menus for that particular piece of data will work.

Nobody knows what I'm talking about?

No, I'm not thinking that.

Is it just the Value List that isn't working properly?

Are you using v7.03?

Lee

Yes, I am using 7.0v3.

Yes, it is only the value lists that don't work.

Portals work fine, the relationships are fine.

Value lists work fine only after a relationship is viewed in a portal.

are the Value List in a Portal?

Lee

No, they aren't in a portal.

Lets see if I'm understanding your circumstances then.

You import data in to a field that is the basis of your value list.

The value list is attached to a field in your Current file.

After import, the value list doesn't update until you

First check that the relationship is valid, and especially that it doesn't have any deleted field in the sort order.

Second, start checking that the layout is based on the correct table occurrance.

Is the value list based on the relationship? Try changing it to be based directrly on the *field* instead, this will display all values.