Don:
If you have FirstName and LastName fields, you don't need a FullName field.
Not only do you not need it, you don't want it. Duplicating information will
only complicate things and require that you synchronize things. What happens
when someone adds a Madien-Married name to the FullName field, like this
Mary Huffnagle ... becomes Mary Huffnagle Hickenlooper
So, does the first name become Mary Huffnagle and the last Hickenlooper
or does the first stay Mary and the last become Huffnagle Hickenlooper?
Now, someone edits the FullName column like this
Mary Huffnagle ... becomes Mary Jo Huffnagle.
Ahhh. It's obvious that Jo is part of the first name, so we would put it in
the FirstName field and leave the LastName alone.
So, leave the first and last names atomic and when you need to display a
Full Name, then concatonate them in a query.
SELECT FirstName, LastName, FirstName & LastName As FullName FROM YourTable
--
Danny J. Lesandrini
dl*********@hotmail.com http://amazecreations.com/datafast/
<dp*****@gmail.com> wrote ...
i am building a movie database in microsoft access. I have a field
for actors last name and a field for actors first name as well as field
for actors fullname. I want the full name field to automatically
populate with the information from the first name and last name fields.
Can anybody help me with this please
Don