NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: JohanR on September 13, 2013, 04:13:12 AM

Title: Auto complete and lookup
Post by: JohanR on September 13, 2013, 04:13:12 AM

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

Title: Re: Auto complete and lookup
Post by: Bruce on September 13, 2013, 08:15:13 AM
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.
Title: Re: Auto complete and lookup
Post by: JohanR on September 13, 2013, 08:27:54 AM

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





Title: Re: Auto complete and lookup
Post by: JohanR on January 16, 2014, 12:36:31 PM

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


Title: Re: Auto complete and lookup
Post by: Bruce on January 17, 2014, 02:08:17 AM
Hi Johan,

>> Has there been any changes to this situation?

no.

cheers
Bruce