Hi,

I'm trying to find a record that has the same field in both records. The records have different fields (one is a search record. In the script "Perform Find" I can't see how to I'm to specify the both fields. Can this only be done with a loop over all records and make the find with an IF statement?

Very greateful for any info on this subjet!!

Kind Regards

Andrew

You can define more than one search criteria, just use the add button after you define the criteria for your second search.

Hi Andrew,

I'm trying to find a record that has the same field in both records. The records have different fields (one is a search record. In the script "Perform Find" I can't see how to I'm to specify the both fields. Can this only be done with a loop over all records and make the find with an IF statement?

If sbg2 has nailed it, great. Otherwise, I'm not sure we are understanding you correctly. Are you looking for data or field names, or Field Types?

Fields don't change, so if you are looking for a field name in one file that is the same as a field name in a second file, then the Find function wont help you.

In this case, it may be helpful to know what you are wanting to do with the found records?

HTH

Lee

Hi Lee

and thanks for your answer,

Yes your where right about my question - it wasn't all that clear. This is what I want to do:

I'm imoprting a record which has 4 fields, one being an ID. With this ID I want to search the rest of the DB, which has different types of records but have the same type of ID-field, these ID-fields are defined as TEXT in both types of records. I suppose that you could call the imported record an identification records or lookup record. Once I find the matching records I want to transfer some of the data in the imported record to the matching one.

So, PERFORM FIND doesn't seem to help me. How would you solve a problem like this ?

Thanks again for your help!

Best Regards Andrew

I'm still unclear of where you are headed with this. In other why do you need to find these files. As such, it may be that all you need to do is use the = (equal sign) in the ID-field. However, it could be that you are looking to portal your data, of you are want to delete duplicates, or something else. So, maybe it's a relationship, or calculation, or something else entirely.

Why don't you post a copy of your files, and the import file, so we can get a better understanding of what you are trying to do. If you post your files, be sure to remove any confidential information.

Lee

Hi Lee

thanks for your time and help.

Hope this can clarify things better;

Established database contains the following fields in each record

ID Number

Description

Weight

Height

Colour

I'll be periodically importing the following data:

ID Number

Price

Distributor

Date

I want the programme to identify the record which has the matching "ID Number"

Once again - thanks for your help Lee!

Best Regards

Andrew

Use the Update and add records feature in the import dialog box. Use the ID Number as your key, and It will automatically update the records. If there are no previous records for the number, it will add new records.

HTH

Lee