Darren DICK
d.dick at uws.edu.au
Thu Sep 9 00:14:25 CDT 2004
Hi Francisco Pretty Basic tblStudents LastName (TEXT) FirstName (TEXT) That's all I want to test. Just if there is one John SMITH and a data entry person is entering a second one, I wanna alert them. I was thinking of a combined dlookup with First and Last name and if the count was greater than zero, alert the user Many thanks Have a great day Darren -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia Sent: Thursday, 9 September 2004 12:42 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] A2K: Same Name Validation As with many things, It depends on the structure of your db my db houses this: Company Address ContactAddress Contact A company can have many addresses. A user may be an employee or associated to many Companies, I associated the contact to the company via the address so I would know what location he is associated through. :D On Thu, 9 Sep 2004 11:25:43 +1000, Darren DICK <d.dick at uws.edu.au> wrote: > Hello all > How do you guys handle data entry users entering someone into a dB > with the same first and last name - quite legitimately E.G. John SMITH > > How do you test for other existences of John SMITH in the db and what > 'alerting' do you guys use? > > Many thanks in advance > > Have a great day > > Darren > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- -Francisco -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com