Entering a new Contact

[simoncpage]

This is what I would like - any ideas on how to achieve it?

Three inputs

1. FirstName

2. SurName

3. Company

So you fist you enter the firstname and surname and as you tab away from the surname a list in a portal of possible matches in the database already

Similiar with the company.

And ideas on this and any pitfals using this setup might incur??

Thanks

[RalphL]

The attached is an old file that may give you some ideas.

I start with last name and show a list of everyone in a portal. The user types in a few letters of the last name and the portal shows only names starting with those letters.

[simoncpage]

This is my current workings...I'm trying to make it so that first field (first name) is searched and then the portal breaks down matches and then the same for the last name making it a tighter list.

See attached and let me know

TAhead_SP.zip

[dbruggmann]

I modified your sample, as follows:

Names2.zip

[simoncpage]

Fantastic! - any ideas how well this will handle 30,000k names?

[RalphL]

It looks very much like the file I attached. I think it will be difficult to get key fields that would allow partial first & last names. The number of combinations would get very large.

[simoncpage]

Fantastic! - any ideas how well this will handle 30,000k names?

[simoncpage]

Sorry Ralph I was just getting round to installing stuff it when I say Detlevs reply....

[dbruggmann]

simoncpage said:

Fantastic! - any ideas how well this will handle 30,000k names?

As the calculation field for the character combinations needs to be stored, it should be quite fast (but it will blow up the file size a little).

[simoncpage]

Yeah I've just imported 20k of records and increased the firstname and surname to 8 characters.....yawn...record remaining to process....tick tock...but its is nice and quick to search with.

I might give it a test with unstored and see how much of a difference I get.

Thanks

[dbruggmann]

The difference will be an invalid relationship