Auto complete and lookup

[JohanR]

Hi,

I am trying to show more detail in the autolookup dropdown.

eg.
smith, a, 12 bird ave, johannesburg
smith, b, 16 eagle drive, dbn

In the code it is cli:name & cli:initial & cli:adr1 & cli:cityname

I get this working except that the whole string is allocated to form field.

Am I missing something obvious?
 or do I try and populate the field manually after the lookup is done?



thanks

Johan

[Bruce]

at this time you can't do this. The result of the auto-complete is used to locate the record ID when the form is saved. So if you customize the auto-complete text you'll need to add code to find the record from that result as well.

[JohanR]

Hi Bruce

thank for reply,

If I understand correctly then the form field needs to be an unique field with a key,
the chosen text is used to locate the correct record?

What I had in mind was to use the "more assignments" list to add the record_id there.

For this situation, will create a lookup button and go to a browse.

Really started enjoying the auto complete!


Johan

[JohanR]

Hi Bruce

Has there been any changes to this situation?
Problem I am having is that I have a file with destination, but these are not unique and filtered by country.

eg. Parys and Parys, both occur in the file, the one in SA and the other is copy in France.

So for the auto complete I would like to have a filter on the file per country, but then if I select the correct 'Parys' it fails, and if I understand correctly Parys should be unique in this file.

I can do a work around using memory tables, but a little cumbersome and not ideal

thanks

Johan

[Bruce]

Hi Johan,

>> Has there been any changes to this situation?

no.

cheers
Bruce