Re: calculation field FM 8

In article
<69776431-dfae-41a6-ba8d-9a23ceff1cbe@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
d-42 <db.porsche@xxxxxxxxx> wrote:

On Mar 19, 6:15 am, Deepti <dpulavar...@xxxxxxxxx> wrote:
Hello,

I have three fields: FirstName, LastName and Email address.
A calculation field : User ID = firstname_lastname (calculation
being : Trim(firstname)&Trim("_")&Trim(lastname) )

When a new record is entered, I need to check if there already is a
record with the same first name, lastname and email address. If the
record exists, I need to add a one at the end of username
(firstname_lastname1).

What happens if someone changes their name or email address? Will
everything linked to that ID break?

It would do, but there are ways to work around it. I use the full name
as the link field in one of my systems, mainly because it's easier for
the data entry people than working with obscure codes. :o)


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
.

Relevant Pages

  • Re: Sub form not displaying as continuous
    ... "John Vinson" wrote: ... >>and data entry = False and no difference at all. ... >>Invoice number does this ... > as the Master Link Field and Child Link Field of the Subform control ...
    (microsoft.public.access.formscoding)
  • Re: Sub form not displaying as continuous
    ... >and data entry = False and no difference at all. ... >looked at the tables and noticed that the Ordersub was not keyed on ... >Invoice number does this ... as the Master Link Field and Child Link Field of the Subform control ...
    (microsoft.public.access.formscoding)