Inserting surname automatically compile name field

[LtPitt]

Hello everybody: I've just registered



I'm trying to understand what access is about and how it can be useful in my professional and personal life...

I'm trying to find out how to do easy input masks.

One of the main point would be to insert a surname (I've found the option to auto-complete while writing: cool) and automatically get a name for it.

I try to explain better: I have two separate fields.
Name
Surname

When I insert Newton I'd like Access to choose directly Isaac.

I hope I made myself clear O_O

Even just a suggestion about what chapter of the help I have to read would be sweet!

Thanks to everybody

[jbarrum]

How in the world, with everything and anything logical, is the program supposed to ascertain that you want "Isaac" to be associated with Newton and not "Bob" or "Fig"

[SoftwareMatters]

This could be way off the mark but what the heck!

Create a table with 3 fields
1. NameRef - 6 characters text (Index and unique) e.g. NEWTOI
2. Surname - 30 characters text e.g. Newton
3. FirstName - 30 characters text e.g. Issac

Create a form with a combobox that shows the surname. Add a textbox who's controlsource targets the combox firstname column.

Everytime you choose a surname from the drop-down the textbox will get filled with the firstname

[jbarrum]

Yes, but how will it know what the first name is? Where is the first name coming from?

[SoftwareMatters]

You tell it.

[jbarrum]

sure sounded to me like he wanted the field [FirstName] in the table to be automatically populated

[LtPitt]

MH good point O_O

I'm novice, that's it.

I thought that storing names and surnames separately could be useful for any kind of future use...
So, to help people inserting fast data I thought about insert just the 1st letter of the right surname "N" and get an autocompilation for NEWTON ISAAC.
Then, if wrong, this could be manually changed...

Maybe I'm wrong?

[LtPitt]

I just had to do a dlookup...

Thanks to everybody anyway