last name field auto loads the email field

[sbrady19]

I have 2 field, a last name field and an email. How would I go about writing code that if the last name is "Hulme", the email field would fill in "Ken.Hulme@company.org"

[orange]

Where would you identify "Ken"?
What happens if 2 Hulme's are with your Company? Would you give both Ken.Hulme@company.org?
Think there's more to this than you have told us.

[sbrady19]

OK from what I have learned from the free tuts on YouTube I did make 2 fields, 1stName and lastName. Yes there could be 3 "Smiths" in the company. So would I have to stitch 1stName + LastName = ken.hulme then make the emailfield:

ken.hulme@company.org.

would I do this in expression builder in Default value. It seems this is only for numbers. How do you concatenate words. I need to get the data from the table, but its not like excel, B4 + C4.

[orange]

Since you mentioned tutorials I'm going to suggest
this one to learn about database and table design and concepts
and point you to some free videos
If you are quite good at learning by Watching/Listening
rather than reading.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

https://www.youtube.com/watch?v=lXAG...6FE5448948D9B4 E-R Diagramming Price and Quantity

Complete set of tutorials on Acc2010.
https://www.youtube.com/playlist?lis...FoilxbUY0yUqZP Reply Reply With Quote