How do I enable the user to look up 2 fields?

[Graham Wickens]

MASTER is linked one-to-one with child PREFIX.

Master has field COUNTRY (Char12)that I want to use look-up on.

Prefix has 3 fields:
1) Prefix [char 5]
2) Full_Country_Name [char 25]
3) Name12 [char12] this is a calculated field
left(remspecial(full_Country_name),12)
I can use Prefix and Full_country_name on their own to lookup the value for NAME12 and put it into COUNTRY field on the master file.
Can I and How do I allow the lookup to Look for *either* (1) or (2)to get value NAME12 in the same lookup?

Sample data

1) = "N" 2) = "USA" 3) ="USA"
1) = "G" 2) = "UK" 3) ="UK"
1) = "A6" 2) = "United Arab Emirates" 3) = "UNITEDARABEM"
1) = "ZS" 2) = "South Africa" 3) = "SOUTHAFRICA"

I want tobe able to use both 1) & 2) to find NAME12 for Master->COUNTRY.
TIA

[Jeff Moses]

RE: How do I enable the user to look up 2 fields?

Graham, If I understand your question, you can do this via some variables. In the form you are looking up from you would need to load a couple of variables first. Let's call them var->vprefix and var->vfull_country. Prior to doing the lookup you would use a method of your choice to load the desired lookup value of Prefix into var->vprefix and the desired lookup value of Full_Country_name into var->vfull_country. Then when you fill out your lookup card in the master table you could use something like this for the filter.

Prefix=var->vprefix.OR.Full_country_name=Var->vfull_country

This would give the lookup table instructions to show only records containing the desired Prefix or Full_country_name. This could be modified to be as complex as you need as long as you supply the values in indivdual variables to the lookup filter. You will probably have to use global variables. The lookup filter wants to find them when you write the expression.
Is this what you want to do?
Jeff

[Graham Wickens]

RE: How do I enable the user to look up 2 fields?

Yup!
it is case of one or the other. but they will have to look up DIFFERENT fields in the lookup table.

[Jeff Moses]

RE: How do I enable the user to look up 2 fields?

Graham, If you want the filter to lookup only a full country name or use only the prefix you could do that by adding a logical variable as the control. Let's use all the work we did so far and add a new logical variable called var->pick. You could, for example put a check box on your form using var->pick and label it "Use full country name". By checking the box the user would make the value of var->pick, .T. Then modify your filter expression as follows:

if(pick=.T.,Full_country_name=vfull_country,Prefix=vprefix)

This would mean than if the "Use full country name" check box was checked, the lookup would only filter records in which Full_country name were equal to the var->vfull_country. If the "Use full country name" checkbox was not checked, the value of var->pick would be .F. and the lookup would filter only those records in which Prefix were equal to var->vprefix.

Jeff