Searching and Entering

[simoncpage]

Hi

Is there anyway that anyone knows of as you are entering a new record being able to search. I want to try to stop duplication so as someone is entering a new contact for example on the left after each entry it is throwing up a search on the side?

Anyone have any ideas?

Thanks

Simon

[ernst]

Hello Simon and welcome,

I think that the easiest way to achieve this would be to have a separate entry layout and then do all checking upon exitting the entry layout.

Regards,

Ernst.

[Charles Delfs]

A few simple ways are to make your customer ID field validate for Unique,

Another is a self relationsip based on the ID field, display the results on the side in a portal.

Charles

[Lee Smith]

Hi simoncpage,

Here is a Tech Article that might be of interest.

http://www.filemaker.com/ti/103792.html

HTH

Lee

[CobaltSky]

Hi Simon,

...as someone is entering a new contact for example on the left after each entry it is throwing up a search on the side?

Sounds like you're talking about a 'type ahead' style feature. - something that is sometimes referred to as 'clairvoyance, where as the user types, entries that start with the same letters are displayed in an adjacent list.

If that is indeed what you mean, then you p[robably fine the folllowing tech info article of interest:

http://www.filemaker.com/ti/103956.html

There are a few demos of the technique also floating around. If you're interested, you might like to visit http://www.databasepros.com/resources.html and do a search on 'clairvoyance' - which will likely produce something useful.