getting lookups to work during import

[ptoly]

Does anyone know the limits of lookups when importing records? I am importing data from a dbf file which should lookup three fields from two other FM files based on three different relationships. The lookups do not work during the import and I have to perform a manual (slow) relookup to get the data into the fields. I created a test file with only the key fields needed and the lookup worked fine during the import. I have the feeling that some kind of calculation or subroutine in my main file is stopping the lookup. Any ideas?

Thanks in advance.

[Kurt Knippel]

Lots more information needed before we could even begin to guess.

Obviously there is something in your configuration that is causing the problems.

How are the lookups setup. What fields are you importing? What else are you doing before and after the import?

[ptoly]

I have three unique text id fields which relate to two other databases: id_record in the importing db relates to id_records in the processed records of the second db. Essentially this is a check writing db. Each of the imported records correlate to a line item on a check to be paid. Once a check has been paid then its corresponding line items are exported to the paid records db. When importing new records from the dbf file I need to cross reference against the paid records db to see which new imported records need to be processed. So there is a field called PaidFlag which looks up the value of the id_record from the paid db file and puts the value 'unpaid' in the field if there is no match. Clearly FM does not see the match as it puts 'unpaid' in every record during the import.

The other lookups are address information for the checks. When a dbf record has a id_client (unique number field) that matches id_client (also a number field) in the address db then Payee, address, and bad address fields get populated. These fields also end up empty during the import but populate just fine with a manual relookup.

Hope this is enough info...

[ptoly]

I should add one more thing; even when I do a manual import, importing only the critical fields and their lookups, the lookups fail. If I create another file containing only the fields I need and do the same the lookups work.